Set Modifier Not Equal to

[akuttler]

Hello,

I have the following expression :

Count({<CPT_CATEGORY != {'Product Sales'}, CPT != {'96567','96920','96922'}>}Distinct Visits)

Where I am trying to count distinct visits that are not product sales and not service code {'96567','96920','96922'}... but it says there is an error in the set modifier expression.

Thanks in advance

[petter · Accepted solution]

The = means "selection assignment" it does not mean equal to.

What should give you the result you are looking for is this:

Count({<CPT_CATEGORY=-{'Product Sales'}, CPT=-{'96567','96920','96922'}>} Distinct Visits )

[Chanty4u]

try this

Count({<CPT_CATEGORY/={'Product Sales'}, CPT/={'96567','96920','96922'}>} Distinct Visits )

or

Count({<CPT_CATEGORY-={'Product Sales'}, CPT-={'96567','96920','96922'}>} Distinct Visits )