Forum Discussion

Sean's avatar
Sean
Icon for Community Champion rankCommunity 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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, 

You can hide the blank value using a Conditional Formatting rule on the Value. The rule is 'if blank' then select the same color as the card or canvas background. 

I have created a video tutorial on how to create the conditional rule in data cards, it should work the same in Multi Row cards : https://youtu.be/Xsmbfpa4oCA

Cheers, Bianca