AnsweredAssumed Answered

Qty Subtraction - Not getting the right answer

Question asked by lindseym on Jan 6, 2017
Latest reply on Jan 6, 2017 by lindseym

Howdy,

 

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.

 

Screen Shot 2017-01-06 at 2.37.47 PM.png

 

 

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.

 

Screen Shot 2017-01-06 at 11.16.58 AM.png

 

 

 

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:

Screen Shot 2017-01-06 at 2.33.40 PM.png

 

Thanks

-L

Outcomes