Calculation Field Problem
This is my second day trying to solve this problem with getting the calculation working on a calculation field called "Processing Quantity", i have included the screen shot of the layout where the Processing Quantity field is located.
I'm trying to get the If ( product_ORDER::Status = "Processing" ; Sum( OrderLineItem 2::Quantity ) + 0 ; "0" ) calculation to work which is set for the "Processing Quantity" field.
It's supposed to get the sum of all the order line items::Quantity with the order status in "Processing" but what it's currently doing is getting the sum of all the Order Line Items with the same Product ID, even if the Order is not in the Processing status.
Please let me know how this can be solved. I tried to get the Relationship table working so that only the orderlineitems get summed up with the processing state and they have to be just the same item.
Here are the screenshots.