Production Order Summary Report Field

td323i
td323i Member Posts: 26
Hello All,
I’ve got a reporting question for Nav 4.0 Sp2. It involves the production order summary report. In the report (which has been modified) we have Material Cost, Overhead Cost and total cost. Total cost = Material Cost + Overhead Cost. The SourceExpr is <MaterialCost + OverheadCost>
We have a field that’s called “Quantity Produced” who’s Source Expr is <Finished Quantity> . We would like to have the average cost total up at the bottom of the page and that would be Total cost / Quantity Produced = Average Cost.
I’m stuck at the formula needed to make this calculation. In my mind the SourceExpr would be <MaterialCost + OverheadCost / Finished Quantity> it doesn’t work so I know its not correct. Anyone have any ideas?

Thanks,
Td