Reply
Regular Visitor
Posts: 38
Registered: ‎05-03-2017

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

Capture.PNG

Community Support Team
Posts: 5,366
Registered: ‎05-02-2017

Re: Cumulative calculation issue

Hi @cthurston,

 

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

 

Best Regards,

Dale

Highlighted
Regular Visitor
Posts: 38
Registered: ‎05-03-2017

Re: Cumulative calculation issue

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.

Community Support Team
Posts: 5,366
Registered: ‎05-02-2017

Re: Cumulative calculation issue

Hi @cthurston,

 

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

Community Support Team
Posts: 5,366
Registered: ‎05-02-2017

Re: Cumulative calculation issue

Hi @cthurston,

 

Did you solve it?

 

Best Regards,

Dale