Exclude Value (selections) in Expression

[Ragnar]

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.

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

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

[hic · Accepted solution]

Remove the 'Status':

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

[Ragnar]

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.