How to exclude 0 values

[Nicole_902]

Hi All,

I'm struggling with what I am sure will be a very simple solution. I am using the following formula as a way to remove any values that are less than 20K from my table. All values that would be >20000 are now showing as 0 but I want to remove them completely. 

Sum( {< SubCategory = {"Reg*"}, UserBudget = {">=20000"} >} UserBudget)

I would appreciate any advice!

[Oleg_Troyansky · Accepted solution]

Hi Nicole,

You should be able to clear the check box "Include zero values" in Chart properties, under "Add-Ons" --> "Data Handling". That should do the trick.

Cheers, 

[Nicole_902]

Perfect! I had to remove another column for this to work, but for the purpose I'm using the chart for that's not an issue. I knew there was an easy solution! I appreciate it 😊