Dear SAC experts, I am trying to create an offset variable to define the calculation's scope.
For example, selected year+1. The selected year is passed through a parameter %CurrentYear%.
I tried the following:
MEMBERSET [d/Date] = (BASEMEMBER(...
Dear SAC experts, I wonder if there is a possiblity to create an offset for the parameter.
For example the selected year +1 (next year) or -1 (previous year).
In the advanced formula it can be archieved with NEXT command.
Dear SAC experts,
I wonder if there is a possibility to distribute one value based on another column values.
For examples, to distribute values entered for 2021 based on values from 2020.
In BEx Query we can do it using the Distribution sett...
I wonder if I can make the delta in the screenshot ready for input using an inverse formula.As far as I know I can only create inverse formulas in the key figure definition. But this is the same key figure in different years.Alternative solution woul...
Hi Jef, thank you, in the planning panel you can distribute "by reference" if you copy and paste values from reference column. But it is rather cumbersome. I would like to execute it on the fly, like in BEx