Need to create a column according to EUR Currency

[rishikeshtiwari]

Hi All,

I have two tables ---

1.     In First table I have Currency, Rates Month and Currency Exchange rates.

2      In second table I have Invoice dates ,item Name ,  Currency,Sales (According to currency in same column) .

         I want to add one more column in this table in which  sales amount  (Column) should convert in EURO Currency(Column)

Actually all the sales amount are coming in that currency which are showing in particular row.

So I want to convert these different types of currency in single currency EUR.

Actually in Fx Table USD Currency is Standard & its value is 1.

So I  need to double applymap.

I have attached a logic of application but I am not able to create a column og Sales EURO.

Thanks   in  Advance

Rishi

[robert_mika]

Your question has been answered here:

Need to change amount according to currency

[jonathandienst]

Hi

I think your exchange rate logic is correct (on tab Main2), but I am not sure what tab Main3 is supposed to be doing and you are missing a ; after the second load on tab Main2.

Your source dates are in multiple formats and your sales amounts are also not being read correcty (they are text, not numeric), so your mapping probably is not working due to the mapping key being incorrect and attempting to multiply a string.

To read the dates and sales, use:

LOAD ....

     Date(Alt(Date#([Invoice Date], 'DD/MM/YYYY'), Date#([Invoice Date], 'YYYY/MM/DD'))) As [Invoice Date],

     Num(Num#(Sales)) As Sales,

     ...

I would use a preceding load for the applymaps, so that you can use the correctly interpreted sales values and dates for your mapping key.

HTH

Jonathan

[rishikeshtiwari]

Thank you so much Robert