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
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