Forum Discussion

adityavighne's avatar
adityavighne
Continued Contributor
7 years ago

Remove Card/KPI Error

Hi team,

 

I want to remove card/KPI error (cross) instead of that I want blank or zero

 

Need Help
Tips and Tricks

4 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    Hi adityavighne ,

    Could you please share more information about your problem? Do you delete a measure? 

    Best Regards,

    Teige

    • adityavighne's avatar
      adityavighne
      Continued Contributor
      7 years ago

      No, I haven't deleted measure.

      This visual is MoM measure so whenever previous month data is not available so the calculation output I want 0 or blank instead of an error.

      • TeigeGao's avatar
        TeigeGao
        Solution Sage
        7 years ago

        Hi adityavighne ,

        Actually, the dateadd() function is a time intelligence function, it rrequires a continous time, you can try to use the IF() function to handle the not available data to zero, for example IF(dateadd(****) = blank() , 0, ***), besides, you will need to create a continous date table which cover the previous date.

        Best Regards,

        Teige