Invert selection in Set Analysis

[#1]

Hi,

to restrict certain clients I use Set Analysis:

Sum ({$<Client={'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

what the correct syntax to invert selection? ie exclude clients 'ABCDE LTD', 'QWERTY LTD', 'Others LTD'?

Regards,

Oleg

[#2 · Accepted solution]

Sum ({$<Client-={'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

Also take a look at this thread as it outline the different operators you can use

Set Analysis: syntaxes, examples

hope that helps

Joe

[#3]

Hi,

Did you tried

Sum ({$<Client-={'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

Thanks

[MK_QSL]

Sum ({$<Client -= {'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

[aveeeeeee7en]

Hi

Try this:

Sum ({$<Client={'*'}-{'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

Regards

Aviral Nag