Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Fill blank values with zero in a pivot table

Hi all,

 

I have created a pivot table with on the left side the article numbers and on the column side the weeknumbers of the year. As value the quentity is displayed. I want to autofill the blank values with the value '0' in the pivol table. 


Can someone help me?

Thanks

 

 

Need Help

1 Reply

  • mlsx4's avatar
    mlsx4
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hi! 

     

    You can store your measure in a variable (var) and then check if it is blank. If true, then you return a 0. Otherwise, you return the value

     

    var _myMeasure= _________
return
IF(ISBLANK(myMeasure),0,_myMeasure)