is there an easy way to not show zeroes??

I have a table that consists of inputs from 3 different sources. What I am running in to is more of an esthetics issue that I am hoping to clean up. I have areas where a zero appears, and other spots they don't appear. The data are all integers so i understand why there would be zeroes showing but confused why it shows up in one column but not there. Ideally I would want the zeroes to just not show up and just leave those cells blank on the card.



Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @user048760

    You can do this with a beast mode to cause 0 values to return NULL / nothing:

    CASE WHEN `Rsvn` <> 0 THEN `Rsvn` END
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @user048760

    You can do this with a beast mode to cause 0 values to return NULL / nothing:

    CASE WHEN `Rsvn` <> 0 THEN `Rsvn` END
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • @GrantSmith Works like a dream. Thank you!