Skip to Content
0
Aug 27, 2023 at 11:54 AM

SAP Analytics Cloud for planning - Calculate Delta between two Dates and Version on monthly basis

147 Views

Hello friends,

I'm currently in the process of calculating the Delta between the Budget for 2024 and the Forecast for 2023. The SAC-Model provides a measure called "Amount," and the data for both the Budget and Forecast are stored in separate versions.

To achieve this, I've established three distinct measures:

  1. Budget 24: This measure involves applying filters for the Budget version and the date of 2024, with Constant Selection enabled.

  2. FC 23: In this measure, I've applied filters for the Forecast version and the date of 2023, again with Constant Selection enabled.

  3. Delta: The Delta measure is obtained by subtracting the Budget 24 measure from the FC 23 measure.

However, the outcome is rather perplexing. While the Year column provides the accurate value, all the monthly values appear to be the same. This issue is clearly visible in the attached screenshot:

image.png

How can I get the correct Delta Values on monthly Basis?.

Thank you for your assistance.

Kind regards,

Ismail

Attachments

image.png (26.2 kB)