on 08-26-2020 1:10 PM
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.