Forum Discussion
Exchange Rate total is wrong
Hi,
I am not sure whether the below is what you are looking for, but please check if it suits your requirement.
same thing
Hi Anonymous ,
If you don't mind, could I ask the following questions? Does your fact table have the currency column? In that case, are you using the physical relationship between your currency field in your fact table with the exchange rates table? Also, exchange rates tends to be reevaluated for different time periods typically every month, and in this case, combination of your fact table currency field with the month information may need to be linked with the currency and month concatenated information in the currency table, I thought.
Multiplication or division depends on how the currency pair is denominated in your particular currency table data.
Best regards,