Ignore Selections Set Analysis

[anushree1]

HI,

I am trying to ignore selections of Year on Set Analysis, in the attached file, using the below expression:

sum({<Flag={1},YearMonthNum={">=$(=vstart)<=$(=vEnd)"},Year>}Actual)

But it is not working, can someone help me to get it

[Nicole-Smith]

You need an equal sign (=) after the field name you want to ignore:
sum({<Flag={1},YearMonthNum={">=$(=vstart)<=$(=vEnd)"},Year=>}Actual)

[anushree1]

@Nicole-Smith 

Still does not work

[Nicole-Smith · Accepted solution]

You also need to include the ignore selection in your variables: