Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Cumulative calculation issue

Hello the issue I am having is that the actuals measure is not showing $0 values.  I'm quite certain that the value provided is blank.  I would like to format it to 0 instead so that the line visual ...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Please try to replace the "Blank()" with 0 in the formula. 0 and "Blank()" are different. 

 

Best Regards,

Dale

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sorry Dale I should have clarified, I have tried replacing the blanks with zeros, and since its a measure it provides s0 for months I dot not want to show.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    I would suggest you add another IF statement that will hide the months you don't want to show and show months you want. Can you share a dummy sample?

     

    Best Regards,

    Dale

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi Anonymous,

       

      Did you solve it?

       

      Best Regards,

      Dale