Why is set analysis condition ignored?

[#1]

In the below formula the conditions highlighted in yellow are ignored by QV, ie. Apples, Oranges and Plums are included though they shouldn't. Lemons are correctly excluded. I guess I should write it in another way but don't know how.

Would anyone help please so that all set analys conditions are adhered to?

Count(DISTINCT {$<SavedReport={'New'},TaskProductName-={'Apples'},TaskProductName-={'Oranges'},TaskProductName-={'Plums'},TaskProductName-={'Lemons'},$(vCalendarFields)>}TaskID)

[MK_QSL · Accepted solution]

Count(DISTINCT {$<

     SavedReport={'New'},

     TaskProductName-={'Apples','Oranges','Plums','Lemons'},

$(vCalendarFields)>}TaskID)

[tresesco]

To exclude multiple values from a single field try like:

TaskProductName-={'Apples', 'Oranges', 'Plums', 'Lemons'}                     

[#4]

Thank you both for your answers! That did the trick.