topic Re: Greater than less than in Set Analysis in App Development

Greater than less than in Set Analysis

LP27 — Sat, 16 Nov 2024 19:02:59 GMT

Hi,

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

This is my table

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!

tresB — Tue, 25 Feb 2020 09:10:09 GMT

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 — Tue, 25 Feb 2020 09:32:03 GMT

Use this condition.

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

LP27 — Tue, 25 Feb 2020 09:34:53 GMT

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

LP27 — Tue, 25 Feb 2020 09:36:53 GMT

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

LP27 — Tue, 25 Feb 2020 09:53:10 GMT

Sorry! The script you posted was right!

Thanks a lot.