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 there, I would recommend doing the currency conversion in the Query Editor or source.
Whilst the lookup does work if your dataset is large or becomes large it will become quite slow
Whilst the lookup does work if your dataset is large or becomes large it will become quite slow