Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @KC3
As long as the currency field is associated correctly in the data model
Unit * "Price Per Unit" * "Total Sale in rs."
@KC3 It is as simple as Unit * "Price Per Unit"*Currency
This should resolve your issue.