Skip to Content
0
Sep 21, 2023 at 12:15 PM

SAC offset variable value/input control value in restricted measure

68 Views

Hello Experts,

I am designing a story based on a measure planning model in SAC; and need to display a 3 columns table with data from different years :

Actual data from YEAR=N-2 ; Budget data from YEAR=N-1 and Budget data from YEAR=N.

I want to do it based on the value a user enters in a prompt (based on a model YEAR variable) or in an input control.

Therefore, my question is if there is any way to apply an offset ("-1" and "-2") on the year value that the user enter in the prompt or the input control , and use those values then in restricted or calculated measure?

Do you have any idea how could I achieve that?

Thank you in advance,

Mickael