Dynamic Time Navigation Functions with Variable in SAP Analytics Cloud

[etienne1110]

Hello,

I'm trying to create different restricted measures in the modeler with the RESTRICT function all based on the same variable ('ZVI_CALYEAR') in order to choose the year to restrict.

I've one measure for Year N which is working well : RESTRICT([Amount],[d/Year]=['ZVI_CALYEAR'])

But I want to restrict also for N+1, N+2 regarding the variable chosen. I've tried to use dynamic time navigation functions (https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/2784376d431e4a7da9564880d...) but it's not working with variable : RESTRICT([Amount],[d/Year]=Next(['ZVI_CALYEAR'],1)) or RESTRICT([Amount],[d/Year]=Next("Year",1).['ZVI_CALYEAR'])

Can you help me,

Thanks, Etienne