If statement...

[#1]

Hi All,

Please see below, what the problem with my script:

IF (CURR='AU','US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL as AMOUNT

Please help me...

THANKS & REGARDS

[prma7799 · Accepted solution]

Try like this

IF ((CURR='AU' or 'US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL) as AMOUNT

Thanks

Prashant

[prma7799]

IF ((CURR='AU' or 'US'), num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL as AMOUNT

[jagan]

Hi,

I think the expression should be

IF ((CURR='AU' or CURR='US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL)

as AMOUNT

OR

IF ((Match(CURR, 'AU', 'US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL)

as AMOUNT

Hope it helps you.

Regards,

Jagan.