Forum Discussion
Solved
Help with currency conversion using LOOKUPVALUE with Exchange Rate month by month
Hey Everyone, I hope that anyone can help me with a problem I have when trying to lookup an exchange rate for a transaction on a given month. I am using an Exchange Rate table as follows: ...
davidanstee Could you please check and confirm whether you have multiple entries for same productid in the same month and year, in that case it might sum up the values. Then you need to select "Don't Summarize" option. The lookup formula looks fine. Regarding your last point, USD to USD and GBP to GBP - Anyway you are hardcoding the TO_CURRENCY value to USD (So everything you want to show in USD isn't it) so what's the purpose of having those same from and to currency values in your lookup table.
Hi davidanstee,
As PattemManohar mentioned, please check whether the field [REVENUE_FORECAST_CURRENCYRATETO_USD] added to table visual is summarized by default. If yes, please change it to "Don't summarize".
Regards,
Yuliana Gu