Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a data set which has all the amount data in USD. I want to have a filter where the user can select if he wants to see the amount in Local currency(Canada Dollar) or USD. The conversion should be done based on the brand country.
For example :
Brand Name | Brand Country | Amount | Type |
A | USA | 3000 | Soap |
B | USA | 2300 | Tissue |
C | Canada | 3400 | Soap |
D | Canada | 2499 | Lotion |
I want the amount to be displayed as per the brand country. Can you please suggest the correct way to do it, I need to do it using filter only.
Thank you
Hi
You can bring one more column value with local currency.
And one filter has local / USD currency.
Load * inline
[
Currency
Local
USD
];
Changed the expression based on the filter selection.
Sum(If(Currency = 'Local', AmountLocal, Amount))
Hi @MayilVahanan ,
My currency rate are stored in an excel sheet in the below format :
Year | YSD to CD |
2020 | x |
2021 | y |
2022 | z |
And I am unable to create Amount local as a separate column , can you please help?
HI @User0
How i tackle this is i bring in the exchange rate at the line level then in the set analysis you can apply the correct currency depending on which the user selected.
SUM(Sales/$(vCurrency))
vCurreny being a variable that picks up the correct column base of an IF statement
I am unable to add the coulmn