Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide rows with 0

hi i have the following scenario, whereby i wish to hide rows that contain 0.

for all values that are 0 in this column i wish not to see them.

i am unable to find a function to make this work have tried supress zero without luck.

1 Solution

Accepted Solutions
Not applicable
Author

If all do you want is something like this (image)

you can try the follow expression:

if ([Period value LC]>0, <expression>) 

in each column that contains one expresión in your Table, always you must be evaluate the expresión [Period Value LC]

resultado.jpg

View solution in original post

2 Replies
Anonymous
Not applicable
Author

In Presentation Tab, select Period Value LC and Clik on Suppress zero values.. if not please upload sample..

Not applicable
Author

If all do you want is something like this (image)

you can try the follow expression:

if ([Period value LC]>0, <expression>) 

in each column that contains one expresión in your Table, always you must be evaluate the expresión [Period Value LC]

resultado.jpg