Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have an issue with variables that use as a flag inside of set analsys.
My variable called 6_Month_Flag:
IF(MonthStart([Calendar date])= AddMonths( MonthStart($(Close_Date_Default)),-6) ,'Y','N')
But when im trying to use it inside of set analsys it just dont work
sum({$<(6_Month_Gap)={'Y'}>}Amount)
I tried so many way but none of them is working.
What is the problem and how can i fix it?
Hi @Reuven12 , you have to use fields, not variables in that part of the set analysis.
So you can create a field using the variable expresion, and then use it
You expression should look like this :
sum( {$< 6_Month_GapFIELD = {'Y'} >} Amount)