set analysis exclude variable

[NickHoff]

Hello,

I have the following set:

COUNT({1<FinancialClassCode ={"1"}, DRG = $::DRG, Facility =  $::Facility, CalendarQuarterYear = $:: CalendarQuarterYear, CalendarMonth = $:: CalendarMonth, JointSurgeonName -= {'$(vExcludeSurgeon)'}>}DISTINCT PatAcctNum)

I'm looking to ignore all selections except the following above.  I added the -= {'$(vExcludeSurgeon)'} which is supposed include all Surgeons except the excluded surgeon defined by GetFieldSelections(JointSurgeonName).

However, the set isn't working correctly and it's still counting the excluded surgeon..

[sunny_talwar · Accepted solution]

Can you try this:

Count({1<FinancialClassCode ={"1"}, DRG = $::DRG, Facility =  $::Facility, CalendarQuarterYear = $:: CalendarQuarterYear, CalendarMonth = $:: CalendarMonth, JointSurgeonName = e(JointSurgeonName)>}DISTINCT PatAcctNum)

[NickHoff]

thanks Sunny

[sunny_talwar]

No problem at all... I am glad I was able to offer help