1 Reply Latest reply on Jun 7, 2018 8:27 AM by Mavis Liu

    sumproduct for weight average

    Javier Rubio

      Hi, I'm trying to move a formula from an excel that is used to provide a weight average, I'm trying a calculated field using If but doesn't allow me aggregations.

       

      The table is similar to the following one:

       

      FeatureValue

      Speed

      4
      Noise

      3

      Speed5
      Comfort1

       

      My idea is to have an average like

       

      SUMPRODUCT(SUM (Feature Value) *SAMPLE(Feature))/SUM(SAMPLE(Feature)^2)

       

      In this case (9*2+3*1+1*1)/4^2

       

      Can someone help me with the calculated field?