Display number field as other dollar amount or percentage.

[BigC72]

I am using CR 8.5. Data comes from a DB2 database. Data is a number field that contains our patients Insurance Co-Pay amount which can be one of three things either 0.00 for patients with no co-pay amount, $25.00 for patients with a particular co-pay amount or .20 for patients whose co-pay is a percentage of the total bill for that day.

The first two values display with no problem of course it's the third I'm struggling with. I'd like to be able to see that .20 value and display it correctly as 20%.

Thanks...

 

[synapsevampire]

Try:

if {table.amount} < 1 then
totext({table.amount}*100)&"%"
else
totext({table.amnpount})

A mixed use for a single field in a table like this is generally a bad idea, I'd suggest that your dba get their application into a Burger King

-k

 

[BigC72]

Thank you for the help, this site has proven to be invaluable...