Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Supress Zeros

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.

replied

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 View this answer in context
Not what you were looking for? View more on this topic or Ask a question