How to use Restrict in calculation workspace sac

[former_member802420]

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,

[N1kh1l]

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

[former_member802420]

Thank you for returning

it’s the Prompt that we want to rely on, That’s why I want to use variables.

It's possible to use in prompt ?