cancel
Showing results for 
Search instead for 
Did you mean: 

Conditional suppress only if all column values are zero

Former Member
0 Kudos

I would like to suppress whole column if dbfield value is 0.00. I was able to suppress it in common tab of format field by using formula if dbfield =0.00 then true else false.

But i would like to suppress column value only when all the values in column are equal to 0.00. Otherwise I would like to retain those 0.00.

Let me know how I can do this?

Your response is appreciated

-Thanks

Raghu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Go to "Format Field...", select the Common tab, and put something like the following in the Suppress formula.

Maximum({dbField}) = 0

Former Member
0 Kudos

Thank you.

It worked.

-Raghu

Answers (0)