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

 

[Majid Umar]

Do U want to have custom format or just want to output blank field if Value is 0 or 0.00. If so U can use IIF function i.e.

=IIf([ItemName]="0","",[ItemName])

Cheers!

 

[Pat Hartman]

You need to remove the quotes from around the zero since it is a numeric field.

=IIf([ItemName]=0,null,[ItemName])

 

[Majid Umar]

Sorry,

Pat is right, I used it for a Text feild and just copied it over.

Regards

 

[davidbetts]

Or use format 0;0;