IF USD(currency) THEN PENNIES ELSE ON PENNIES

[kbasha2004]

Hi Friends,

I need to fix the dollar values in the report as "IF USD(currency) THEN PENNIES ELSE ON PENNIES"

Example ..
$2000.20 USD...........in case USA
# 2000.....................in case UK ot other country.

Please help me.Thanks in Adv

Kbasha

[MFGF]

Hi,

You could try using the floor() function to remove the decimal part of your value where the currency is not USD.  Does this give you what you need?

Regards,

MF.