Set Analysis

[risabhroy_03]

I have a variable vFiscalYear which stores a value of 2022.

I am using it as below - 

Sum({<Budget_Year={"$(vFiscalYear)"},Budget_Month={1}>}RM)

But I want to my Budget_Year to pick 2023 for some cases.

Can you please help me to add +1 , I tried but it is not working

Sum({<Budget_Year={"$(vFiscalYear)+1"},Budget_Month={1}>}RM)

[tresesco · Accepted solution]

Try like:

Sum({<Budget_Year={'$(=$(vFiscalYear)+1)'},Budget_Month={1}>}RM)