Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to use set analysis to limit a table of orders based on certain conditions, which are:
- The order must be have an OrderType of 'Booked'
- The order must either have a Class of 1 or a Category of 1
i.e. OrderType = 'Booked' AND (Class = 1 OR Category = 1)
I've been trying to write some set analysis using intersection but i can't get it right and always gives me errors. Can someone help?
Thanks
Sum({<OrderType = {'Booked'},Class = {1}>+<OrderType = {'Booked'},Category = {1}>} Sales)