Set Analysis - And statement for same field

[#1]

I am trying to write a set analysis for our consumers who are on 6 or more medications and 10 or less medications (i.e. taking anywhere from 6 - 10).

This is my expression so far:

Count( {<Year=,Month=,[Medications Total]={'>=6'},[Medications Total]={'<=10'}>} _ConsumerProfileKey)

I want year and month to be null so that's taken care off.

This expression is only giving me consumers who are taking 10 or less medications and is disregarding the 6 or more condition. Is there another way of writing this a different way?

I've spent the last hour with no success

[Gysbert_Wassenaar · Accepted solution]

Have you tried this:

Count( {<Year=,Month=,[Medications Total]={">=6<=10"}>} _ConsumerProfileKey)

[#3]

Worked perfectly. Thank you so much!