cancel
Showing results for 
Search instead for 
Did you mean: 

How to use Restrict in calculation workspace sac

0 Kudos
197

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,

View Entire Topic
N1kh1l
Active Contributor
0 Kudos

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

0 Kudos

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 ?