Formating 0.00 to blank

[sdeep_us]

Hi,

I want to change the format im my report for the value 0 to blank(null) and also 0.00 to blank(null).

Please let me have the custom formats for the same

Thanks
Sandeep

 

[Scott_S]

You can try

In Control Source on field name you want to display as null where fldname is the name of your field:

If([fldname]=0.00,"",[fldname])

or

If([fldname]=0,"",[fldname])

Prob better ways to do this but this should work.