How to write code for sales multiple by currency ?

[paulyeo11]

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

[_armoco_]

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?

[paulyeo11 · Accepted solution]

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