Greater than less than in Set Analysis

[LP27]

Hi,

I am not sure how to use greater than and less than in set analysis for the below condition - 

This is my table 

OrderNo	Waiting days	Result
1	3	Met
2	8	Canceled
3	6	Met

Now i want to count the Orderno where waiting days is >=1 and Waiting Days is <=7 and Result is  not'Canceled'

 I have used : -

Count({$<[Waiting Days]={">=1<=7"},[Results]-={'Cancelled'}>} OrderNo)

This is wrong and not giving right output. Could someone guide me what is the best way to write this set analysis ?

Thanks in advance!

[tresesco · Accepted solution]

The way you are trying seems to be fine. Just try correcting your field name and value like highlighted in red below:

Count({$<[Waiting Days]={">=1<=7"},[Results]-={'Cancelled'}>} OrderNo)

[maniram23]

Use this condition.

Count({<[Waiting days]={'>=1<=7'},Result-={'Canceled'}>}OrderNo)

[LP27]

I fixed the value and field names, its still the same.

[LP27]

No this does not produce any results. It showing blanks.

[LP27]

Sorry! The script you posted was right!

Thanks a lot.