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

    Sum Average of average

    jesus.gonzalezballesterq.7

      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

       

      Header 1Header 2
      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