1 Reply Latest reply on Apr 9, 2018 10:13 AM by patrick.byrne.0

# Sum Average of average

HI, I have those measure to calculate the average:

[2 1 2 Pass Rate] = SUM([2 1 2 Pass])/SUM([2 1 2 Pass] + [2 1 2 Fail])          //that give me the average of  2 1 2 Pass Rate result is 1.00

[2 1 3 Pass Rate] = SUM([2 1 3 Pass])/SUM([2 1 3 Pass] + [2 1 3 Fail])          //that give me the average of  2 1 3 Pass Rate result is 0.9807

[2 2 1 Pass Rate] = SUM([2 2 1 Pass])/SUM([2 2 1 Pass] + [2 2 1 Fail])          //that give me the average of  2 2 1 Pass Rate result is 1.00

[2 2 2 Pass Rate] = SUM([2 2 2 Pass])/SUM([2 2 2 Pass] + [2 2 2 Fail])          //that give me the average of  2 2 2 Pass Rate result is 0.8567

`Now I need to create a formula calculation for the average of all these values, but if one of this average is NULL, do not use it for the average calculation .    `

Exampel1

2 1 2 Pass Rate1.00
2 1 3 Pass Rate0.9807
2 2 1 Pass Rate1.0
2 2 1 Pass Rate0
Average Pass Rate0.9829

Example 2

Pass Rate

Average

2 1 2 Pass Rate1.00
2 1 3 Pass Rate0.9807
2 2 1 Pass Rate1.00
2 2 1 Pass Rate0.8567
Average Pass Rate0.9593
• ###### 1. Re: Sum Average of average

Hello Jesus,

I believe with a nested IF or IFNULL statement you can achieve the desired result.

I would also attach a packaged workbook with your attempts if posible.

I hope this helps!

Cheers,

Byrne, Patrick