Home Forums Power Pivot Cube Functions – Return a 0 instead of Null

This topic contains 2 replies, has 3 voices, and was last updated by  ShaneSuzanne 1 month, 1 week ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #5378

    rsmallwood0507
    Participant
    • Started: 3
    • Replies: 1
    • Total: 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

    #5380

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2558
    • Total: 2565

    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.

    #17995

    ShaneSuzanne
    Participant
    • Started: 0
    • Replies: 1
    • Total: 1

    Tomallan – that worked perfect!  Thank you!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.