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!
Modelling/Data Info: Planning model, Imported Data, Classic Model Type
- SAP Managed Tags:
mwickman
mwickmanThere is a standard YoY business function available in SAC. I would suggest you should try that. Its not available in stories but in classic model you can get in calculated account formulas.
YOY([Quantity_sold],[d/Date])
Output:
The disadvantage is that you need a separate account for each measure.
Hope this helps !!
Nikhil
| User | Count |
|---|---|
| 65 | |
| 8 | |
| 7 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 5 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.