topic Exclude Value (selections) in Expression in App Development

Exclude Value (selections) in Expression

Ragnar — Thu, 13 Oct 2022 19:39:41 GMT

Hi Community,

I'm unable to resolve what the error is in this expression as I get a 'Error in set modifier expression':

=count({<Status-={'Dead Enquiry'} Status, transferred={"-1"},Year={2021}>}EF_No)

Purpose of the expression is:

Count the Number of EF_No (Enquiry Number) whilst Excluding 'Dead Enquiry' in the Year 2021 with the orders that have been transferred which is -1 (true)

I wish to see all orders that have Won excluding those have loss i.e. dead enquiry.

I tried another expression:

count({$<Status-={'Dead Enquiry'}>} Status) AND transferred=-1 AND Year=2021 and EF_No

which was OKAY but didn't produce any values.

Any guidance on where I'm going wrong is appreciated.

Thanks for your time.

Re: Exclude Value in Expression

Anil_Babu_Samineni — Tue, 22 Mar 2022 15:38:03 GMT

Perhaps this?

count({$<Status-={'Dead Enquiry'}, transferred={'-1'}, Year={'2021'}, EF_No=>} Status)

Re: Exclude Value in Expression

hic — Tue, 22 Mar 2022 15:38:52 GMT

Remove the 'Status':

=count({<Status-={'Dead Enquiry'} Status, transferred={"-1"},Year={2021}>} EF_No)

Re: Exclude Value in Expression

Ragnar — Tue, 22 Mar 2022 15:48:46 GMT

Both of you are legends, both expression work and can't believe it was something small as opposed to what I thought it would be.

Also, I'm shocked at the effcient response time, genuinely appreciate it. Thank you Anil & Henric.