Using OR in Set Analysis

[rittermd]

I am attempting to get this syntax correct and just can't get it.

I want the logic to be:   LOB is one of the values AND CancelCurrentYearFlag is Yes OR PercentFlag is Yes.

I currently have:

Sum({1<LOB={'Base','Other'}, <CancelCurrentYearFlag={'Yes'} > + <PercentFlag={'Yes'}>} Revenue)

Something is off!!!!

[Or]

Looks like a missing closing >  (or an extra opening <). You have three < and only two >.

Another thing that looks suspicious is that you have applied 1< to the first set but not to the second set in the union, is that intentional? This might not be the case because with the missing > it's hard to tell what the 1 should be referring to.

[albertovarela]

You have 1 extra <. remove this one <

Sum({1<LOB={'Base','Other'}, <CancelCurrentYearFlag={'Yes'} > + <PercentFlag={'Yes'}>} Revenue)