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

4 Replies

  • 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