Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like this
IF ((CURR='AU' or 'US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL) as AMOUNT
Thanks
Prashant
Try like this
IF ((CURR='AU' or 'US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL) as AMOUNT
Thanks
Prashant
IF ((CURR='AU' or 'US'), num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL as AMOUNT
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.