Supress Zero Values 1

[kmPremier]

Hello,
I am attempting to suppress the Zero Values in a report.
I attempted to do the following formula:
if {ARIBD.AMTEXTN} = 0
then " "
else {ARIBD.AMTEXTN}

However my "else" statement gets rejected saying that I need a string here...

Any thoughts? I truly appreciate any help I can get on this.

Thanks!

 

[bdreed35]

Instead of creating a formula, write some code in the conditional suppression for your {ARIBD.AMTEXTN} field.

Right click the {ARIBD.AMTEXTN} field on the report, and choose format field.
Under the Common tab, select the X+2 button to the right of the Suppress property.
Add the following line in the editor:

{ARIBD.AMTEXTN} = 0

Save and Close and Test it.

~Brian

 

[kmPremier]

Thank you so much!
That worked perfectly, I knew it had to be something fairly simple, I just couldn't, for the life of me find it.
Thanks again!
K

 

[synapsevampire]

Or just right click the field, select format field->Number->Customize and check the Suppress if Zero.

No code required.

-k