4 Replies Latest reply on Apr 27, 2018 9:34 AM by Hannah Keith

# Average of a Max Calculation

Hi,

I'm trying to calculate the average production run length for a set of assets. The calculation would need to incorporate Product Name and Description and Day of Run. The run length would be the MAX Day of Run for each Product Name and Description on each Asset Name, then I'd need to take and average of that but am unsure how to set up the calculation. Any help is appreciated!

Hannah

• ###### 1. Re: Average of a Max Calculation

Hi

is this what you expected

I think this is what you described in the post

then the avg is this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: Average of a Max Calculation

Not quite - when I do the calculation manually in Excel this is the result. It looks like your calculation is taking the average across all assets for the longest run on each while I'm trying to take the max on each product on each asset to then average to get the average run length on each asset

• ###### 3. Re: Average of a Max Calculation

OK

Help me through the math / nomenclature here

I translated  your post  The run length would be the MAX Day of Run for each Product Name and Description on each Asset Name

to a formula like this

{ INCLUDE [Product Name And Description],[Day of Run],[Asset Name]:max([Day of Run])}

where the max day of run it the run length - is that the value you want to use?

Jim

1 of 1 people found this helpful
• ###### 4. Re: Average of a Max Calculation

I tweaked your calculation to { INCLUDE [Product Name And Description],[Asset Name]:max([Day of Run])}, and it now works perfectly. Thanks for your help!!