Forum Discussion

Paolo_lito's avatar
Paolo_lito
Frequent Visitor
4 years ago
Solved

Zero instead Blank in a filter context

Hi , Hope you can help me on this subject . I would like to have zero instead Blank in my Matrix  but only for the filtered value   If I add a Zero as suggested the most of the time then ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Try 

    VAR Code = Your Code

    VAR Result = IF ( ISBLANK ( Code ), 0, Code )

    Return

    Result

serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
4 years ago

Hi,

i have seen your measure with the zero at the end.

instead you can try without the ending zero but creating a new measure = the name of the basic measure +0

 

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !