Forum Discussion
Currency Conversation
I have a fact table which has Invoice amount,currency( having mutiple currencies),invoice number also have another table currency conversion which has Starting currency, distination currency, exchang...
Hi Anonymous ,
was your problem solved?
Sample Data attached. I need the final report of invoice amount in $ value.
v-diye-msft
Community Support
Community SupportHi Anonymous
Would you like to get the invoice amount based on the JPY? and exchange rate is limited in the date? there are no range dates for any specific pair of starting currency to destination currency, that's unable to determine the exchange rate in your invoice date.
You might refer to the similar post below for some pointers, if you'd like to get the exact results, kindly elaborate more details.