Supressing Symbols for 0's when merging into one field

[PjwJF]

Hi All,

I'm adding multiple percent fields to a text box. I have replaced the currency symbol for a percent symbol and switched the display to show after the record. e.g., 100% instead of %100

There are zero's in this field, both the 0 and the % are suppressed until I merge it into the text box with the other fields I am combining. The records that are 0's then appear as "-%".

What can I do to suppress the "-%"?

Thanks!
PW

 

[lbass]

Create a formula to use instead of the percent:

if {table.percent} = 0 then
"" else
totext({table.percent},0)+"%"

-LB

 

[PjwJF]

Perfect!

Thanks,
PW