Multiple Countries amount multiplication in sale

[KC3]

Hi Qlikiance,

I wanted to get the total sale number to multiply  unit *Price per Unit* currency as per countries 

Country	SKU	Unit	Price Per Unit
Export-Us	Sale_2	4	5.32
Export - Bhutan	Sale_3	5	6.84
India- Bangalore	Sale_4	8	399
India- Mumbai	Sale_3	9	499
India- Kolkata	Sale_2	6	399

In the above table country exchange rate is not mentioned
As my data is too big mainly we deal in India 5-6 export data will be there in a month.

Please help to get the total sale from the formula. I know  we can make a exchange rate table and map that but i don't want to do that so help me with the formula.

Below are the table for understanding mainly I  need F as output.

Thanks in advance

KC

[Mark_Little]

Hi @KC3 

As long as the currency field is associated correctly in the data model 

Unit * "Price Per Unit" * "Total Sale in rs."

[sidhiq91]

@KC3  It is as simple as Unit * "Price Per Unit"*Currency

This should resolve your issue.