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 ...
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