Home › Forums › Power Pivot › Cube Functions – Return a 0 instead of Null Tagged: Cube Functions, Cube Value, Null This topic contains 2 replies, has 3 voices, and was last updated by ShaneSuzanne 3 months ago. Viewing 3 posts - 1 through 3 (of 3 total) Author Posts July 26, 2016 at 2:52 am #5378 rsmallwood0507Participant Started: 3Replies: 1Total: 4 Hello, I am attempting to return a zero instead of null when the cube function returns a null value. Obviously this can be easily done with an If, but my 200+ measure report needs all the performance help it can get! Thanks! Rhett July 26, 2016 at 5:52 am #5380 tomallanKeymaster Started: 7Replies: 2580Total: 2587 Rhett, On the Excel side, try wrapping the cube formula inside of an N() function. If that does not work consider changing null in your source to 0. June 13, 2019 at 5:32 pm #17995 ShaneSuzanneParticipant Started: 0Replies: 1Total: 1 Tomallan – that worked perfect! Thank you! Author Posts Viewing 3 posts - 1 through 3 (of 3 total) You must be logged in to reply to this topic.