I'm working on a layout with a sub-summary part definition.
Actual Qty is a summary calculation with running total and restart summary selected.
The first issue I am having is that the difference column (WO QTY - Quantity Qty) seems to be factoring other numbers after the first line item.
The second issue, I want to figure out how to show it if the difference is more than the work order to show as a positive number, if it is less, to show as negative. I think I can do this with a calculation like: If the difference between WO and Actual is greater than WO then add a + sign before the difference and format green. If the difference between WO and Actual is less than WO then add a - sign before the difference and format red. I am sure I can figure out that calculation. Just want to make sure that sounds like a viable option.
Here is what I am getting in preview mode: