Forum Discussion

Sean's avatar
Sean
Community Champion
10 years ago

Blank( ) in Card/Multi-row Card

Is there an easier way to output 0 instead of blank in a card / multi-row card   I've been using => IF ( ISBLANK (expression), 0, expression )   Is there any way to avoid repeating the expression...
Need Help
austinsense's avatar
austinsense
Impactful Individual
10 years ago

Little simpler, but you still have to repeat the expression IF ( [Measure], [Measure], 0 )

LLABROOY's avatar
LLABROOY
New Member
9 years ago

I'd also be interested in how to remove (Blank)

 

This is made up of individual Card vizulisations and i have lutiple different revenue and count cards over my report that i would need to create a measure for to remove (Blank) Is there a way to create a report level filter or at least page level filter that changes this to some relevant '0' or '-' . 

 

 

 

  • shebr's avatar
    shebr
    Resolver III
    8 years ago

    Hi LLABROOY,

     

    Have you tried doing a 'replace' in your query editor, see image below. If you right click on the column and replace null with 0, this may resolve your issue.

     

    Let me know how you get on.

     

    Thanks

     

    shebr