Skip to Content
0
Jan 05, 2023 at 10:35 PM

YoY Calculation across versions

170 Views

Greetings,

I have a requirement to show YoY change and % Change in a table, which works reasonably well when only one version is used (e.g. ACTUALS) using the Difference From calculation. However, I need to be able to create this table with a combination of ACTUAL + FORECAST version data. Is this possible? My attempts to create this calculation (via cross-calculation of Versions in tile filter and other methods) have had unexpected results (screenshot below). Also I have noticed that using the 'difference from' calculation does not provide results for the 'Year', is this by design?

Thank you!

yoy-calculation.png

Modelling/Data Info: Planning model, Imported Data, Classic Model Type

Attachments