Supress Zeros

[Former Member]

Good Day All,

I've a formula

if {usp_wb_Reporting_F10_FI_Maturity_and_Quality_Dist;1.Category} = "Maturity Distribution"

Then {usp_wb_Reporting_F10_FI_Maturity_and_Quality_Dist;1.Issues}

else " "

Error "A Number Is required".

The reason I want it blank is that I could supress using section expert.

Is there a way to do this.

If I that out the else it gives me 0.00 and I can't supress 0.00.

Any suggestions would be greatly appreciated.

Thanks

David M.

[Former Member · Accepted solution]

There could be another possibilty and that is if you click on the field.

Right click on the field during the preview mode, click format properties, Common tab, click on suppress and type in there

currentfieldvalue=0;

make sure suppress option is ticked and click ok.

That should do the trick.

Regards

Jehanzeb

[Former Member · Accepted solution]

Thanks Jehanzeb,

THis is exactly what I needed.

Thanks,

David M.

[Former Member]

Did you try this?

if {usp_wb_Reporting_F10_FI_Maturity_and_Quality_Dist;1.Category} = "Maturity Distribution" 
Then totext({usp_wb_Reporting_F10_FI_Maturity_and_Quality_Dist;1.Issues})
else " "

Regards,

Raghavendra

[Former Member]

Good Day Raghavendra,

Though your suggestion worked it open other problem with summary and formatting extra .00 that can't be formatted using format object since it is now text.

But thanks for you input I could use it in another senerio.

Thanks

David

[Former Member]

Ok change it to 0 and then make sure under File Menu Report Options you have unticked the box which states

Convert other null values to default.

If you check this box it will convert null values to 0 or in your case 0.00 whereas if you leave it unchecked it will leave them as blank.

Regards

Jehanzeb