Basically I need this.
If item.class != ‘Assembly’ then return 0
What I want on the SS is to only display orders with items that do not require Assembly. As we get multiple orders over the course of the day we do get orders that contain items with Assembly and also contain items that don’t require Assembly these types of orders I do not want to display in the SS results.
As far as what I should see in the SS this would be the format.
SO, Date Ordered, Total Value
Not much else the reason for this is so that we can send these particular orders to a different area of the company to fullfill and send the orders with Assembly items to another (yeah kind of silly but this is what I have been asked for)
-
This reply was modified 6 years, 3 months ago by Ian Ford.