Production Order Labor Efficiency > Add overall average to footer?

Hi @hayleehicks18! It doesn’t look like the image or what you are linking is showing up, can you try again?

Hi @hayleehicks18! This is a little tricky because one part of the variable’s expression calculating the average can result in a 0 on a the denominator, causing the NaN to show.

For me I broke out the expression for Total Efficiency into three lines:

So the result is 1/0, which can’t happen obviously.

So to get around this you’ll need to adjust this expression so it will never return a 0, then the NaN will stop coming in.

After that you can add the Report Footer section and create a new variable $TotalAverage like:

=$TotalAverage+( $TotalEfficiency/$TotalOperations):

Then display it in the Report Footer:

This should keep a running total now of the averages, as long as none of them are NaN.

Next you’ll need to add another variable to the header where the Production Order shows:

This way you have a count of how many production orders are in the report, then you can divide the $TotalAverage variable by the $Line variable to get the average for all the showing orders:

This is how I did it, but the MFG module isn’t really my expertise, so I don’t know the best expression to stop the denominator from appearing as 0 (I just replaced it with 1 in my tests).

Let me know if this helps