Report formatting - how to avoid display zeros in a column

[Former Member]

Hi Guys,

I hav ethis problem. One of my report columns give figures and some of the figures has a vlaue of zero (0). I dont want to display zero , what I want is when the value is zero in the cell have it blank.

whats the best way to do this

Thanks

Sonny

[former_member203619 · Accepted solution]

I would recommend using a formula for it. Just do a check to see if the value is 0 and if it is - return back a blank, otherwise return back the proper value.

-

---

a programmer learning programming from perl is like a chemisty student learning the definition of "exothermic" with dynamite