Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks, I am trying to remove the zero values from my straight table. Then I selected "Suppress Zero Values" on the presentation tab for straight table. But still the it returns the zero values on the Table.
Can I still check any other conditions or It is a bug on the software ?
Appreciated!......
All expressions should return "0" in order to a row to be hidden, check the other expressions result
It should work
Are you sure the values are 0?
Maybe 0.00% could be 0.0000125% and therefore not quite a zer value????
I believe, If we rounded the value to 2 precision values and the returned value should be zero
Use round
round(yourexpression,0.01)
Seems you should set value as null() when it is zero and supress null