Formula to output blank or - instead of 0

[robercr12]

hi ,

I am using CR v10.

if {@MonthRange} = ' 9 Months'
then 1
else 0

When i create a summary based on this in RF i obviously get 0 in someplaces.

How can i replace the 0 with:
1)nothing
or
2) -

Thank
bob

 

[AndyMc]

Right click on the summary field, choose Format Field, go to the number tab, press the customize button, and use the drop-down on "Show Zero Values As".

 

[robercr12]

Thanks

Regards
bob

 

[lbass]

Or in the customize screen, check "suppress if zero".

-LB