Supress Zeros

This question is answered

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.

Correct Answer

October 08, 2008 at 18:29 PM

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

0 Likes 0 View this answer in context