Forum Discussion
calculating a margin base on multiple lines
hi i am new and somewhat lost at this point. we use production orders that may have many lines. i am able to calculte the margin on the whole production order but not by individual lin...
Hi Frankcf
So in the sample you provided. You have highlighted the two Margin values. $8.60 and $2.92. Do you simply want to add these together to get a value of $11.52 and divide them by 2 because there are two Prod_# ?
hi
thanks for the response,
each of those $margins are from a different production order #, so the first value of $8.60 is divided by the number of lines in that production order.
the second value of $2.92 is divided by the number of lines from it's different prodcution order #