Hello all,
I am writing this question in reference to the process of currency conversion in SAP Analytics Cloud.
The problem is that we would like to make a conversion to Ordinary Euros with an specific formula, detailed below:
1. Aggregate the MTD (local currency) amounts to obtain YTD (local currency)
2. Offset the YTD (local currency) amount by the appropriate month's exchange rate
3. Calculate MTD (EUR) as a result of the difference between the current month YTD (EUR) and the previous month YTD (EUR).
The following table shows an example of this conversion:

Below you can see the detail of the calculation made in the table for each month:
Is there any way of doing this conversion in SAP Analytics Cloud?
Thank you so much in advance!