Zero and space in Data

[Former Member]

Hi,

I have Table

If there is no value few fields are showing space(blank) and few fields are showing zero's.

Please let me know what formatting option should i select to make same.

Thanks

Sudhakar

[Former Member · Accepted solution]

If all fields in table are of type text then don't assign value to the field when it is ZERO(in the back end itself). If some are numeric and some are text then use the formula (formatting->custom) for numeric fields :

if(@X==0,'',@X).

[Former Member · Accepted solution]

Hi Hari,

Thank you very much.

Thanks

Sudhakar