on 2022 Nov 07 5:17 PM
Hello,
In calculation workspace, I want to create a variable budget year N and N-1 with formula restrict it is possible ?
2022-11-07-18-10-36-sap-analytics-cloud-et-6-pages.png
Thanks,
Request clarification before answering.
betarek
Under the calculation space, create two calculated measures as below. I have used QUANTITY Measure as my base measure
N (current) Year Budget, Use dynamic time filter to adjust. Unfortunately variables are not supported here. You can try with calculation control in stories but not in model level.
RESTRICT([QUANTITY] ,[d/Date]= Previous("Year", 1)AND[d/Version]="public.Budget" )
N-1 (previous year) Budget
RESTRICT([QUANTITY] ,[d/Date]= Current("Year") AND[d/Version]="public.Budget" )
Hope this helps !!
-Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
30 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.