Print Page - IF USD(currency) THEN PENNIES ELSE ON PENNIES

Title: IF USD(currency) THEN PENNIES ELSE ON PENNIES
Post by: kbasha2004 on 16 Nov 2007 05:22:00 PM

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

Title: Re: IF USD(currency) THEN PENNIES ELSE ON PENNIES
Post by: MFGF on 19 Nov 2007 05:03:10 AM

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.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: kbasha2004 on 16 Nov 2007 05:22:00 PM