Good Morning.
I have a need to consolidate currencies from various countries. The currency and exchange rate for each Country is different. The data source has each day's exchange rate I am able to use. Among the fields available are:
County,
Date,
Exchange_Rate - (associated to the Date),
Currency_Code - (Local, USD, EURO)
Revenue.
When I select one Country only I get a Total for the expression but when there are multiple Countries selected, I have to select Total Mode "sum of rows" to get a Total. I would think that this is something to do with AGGR, but I cannot get it correct. The expression I am using is:
"AGGR(sum(Revenue)/Exchange_Rate,County,Date)"
I have also tried:
"AGGR(sum(Revenue)/Exchange_Rate,County,Date,Currency_Code )"
Please can someone assist with the reason for this.
Thanking you.