Skip to Content
0
Jun 09, 2020 at 06:51 PM

Currency Conversion - Convert to Ordinary Euros

210 Views Last edit Jun 09, 2020 at 06:55 PM 3 rev

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:

  • January: 100/1,2 = 83,33
  • February: (220/1,1)-(100/1,2) = 116,67
  • March: (325/1,15)-(220/1,1) = 82,61
  • April: (440/1,18)-(325/1,15) = 90,27

Is there any way of doing this conversion in SAP Analytics Cloud?

Thank you so much in advance!

Attachments

capture.png (6.8 kB)