Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi,
Did you tried
Sum ({$<Client-={'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)
Thanks
Sum ({$<Client -= {'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)
Hi
Try this:
Sum ({$<Client={'*'}-{'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)
Regards
Aviral Nag