range between in set

[mallireddy_qv6]

Hi all

I want below in set analysis

Count({<ids=[500,...,950]>}Sales)

Instead of describing all of my ids between 500 and 950...?

[Chanty4u · Accepted solution]

hi,

can you try this.

Count({<ids = {'>=500<=950'}>}Sales)

best

chanty

[mallireddy_qv6]

thank you. I want to  exclude . below values

how to do?

product  not equal to "A,B,C"

[Chanty4u · Accepted solution]

you can try like this

Count({<ids = {'>=500<=950'},Product-={'A','B','C'}>}Sales)

[mallireddy_qv6]

thank you.  its working.

[Chanty4u]

cool can you close this thread as accept as solution.