Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a sales table.My org code :
[Row Total] AS sales,
it have CURRENCY field :-
EUR
SGD
USD
I think the new code should be :-
if (CURRENCY='USD' , [Row Total]*1.3),
if(CURRENCY='SGD' , [Row Total]*1),
if(CURRENCY='EUR' , [Row Total]*1.6) AS AMOUNT
But it cannot work.
Paul
Hi Sir
Thanbk you very much for your help. By the way some one have share with me the below script , and is working fine now.
([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) as sales,
Paul
Hi Paul,
Can you describe the error that you are getting?
I can see that you have renamed [Row Total] as Sales? Perhaps use Sales instead of [Row Total]? Also are you closing off all the brackets of if condition?
Hi Sir
Thanbk you very much for your help. By the way some one have share with me the below script , and is working fine now.
([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) as sales,
Paul