Hi Pigment Folks,
I have the following FX conversion rate challenge,
I build my Balance Sheet from staging transaction amounts in local currency from Transactions list and structuring the amounts over a hierarchy were account number is the lower level.
My problem comes when trying to convert the amounts to our reporting currency.
- I have a metric where I input the conversion rates on a monthly basis.
- The balance sheet has the following behaviour: Every month, the cumulative amounts should be converting to the latest rates. And every year should be converting to the last month of the year rates.
I’m looking to create an FX metric that I can apply to the staged amounts that it’s flexible.
I mean that whenever I’m showing data by years, quarters and months select the right rates.
Hope you can help here :)
Thanks in advance.