4 Replies Latest reply: Oct 26, 2017 12:06 PM by Maria Gonzalez

# Calculation each Line of Order and Sum the total

Hello,

I need to calculate the total Boxes; the calculation is by each LineNumber (Quantity / CapacityBox)  then Sum the result for each line . I did with the next variable, but my result looks different, I insert into the table the calculation is by LineNumber, however I need to have the total calculation into variable.

/

Sum the Total for Each Line Estimated = Quantity / CapacityBox

Somebody can help me?

Thank you!

• ###### Re: Calculation each Line of Order and Sum the total

Not sure I understand what you are looking to do? What is the black box in the image suppose to show?

• ###### Re: Calculation each Line of Order and Sum the total

For example:

Order Number: 90002419 has 4 lines 0,1,2 and 3 each line has Quantity / Capacity Box, the calculation is good into the table= Box Estimated  but in the total is not good the result  also the variable is not correct because is taking the total of quantity and total capacity. I want to Sum each line = Box Estimated column.

Goo result should be like this

 Box Estimated 0.200 0.100 0.250 0.500 Total Sum    1.050
• ###### Re: Calculation each Line of Order and Sum the total

Try this

Sum(Aggr(

/