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.
Jehanzeb Navid 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