Set Analysis - Multiple Qualifiers on Same field - Less than

[Anonymous]

Couple of questions here -

1. What is the best way to apply multiple qualifiers to the same field in set analysis?

2. What is the best way to apply a less than qualifier to a certain field?

Example is below: Trying to count distinct items where the Code is NOT LIKE 152621* and is less than 15400000

count({<

[Code]-={'152621*'},

[Code] ={"< $(=15400000)"}

DISTINCT(

[Item Number]))

[sunny_talwar · Accepted solution]

Try this:

Count({<Code -= {'152621*'}>*<[Code] ={"<15400000"}>} DISTINCT([Item Number]))

[Anonymous]

That worked. Thanks Sunny.

[sunny_talwar]

Awesome