7 Replies Latest reply: Aug 24, 2012 6:02 AM by Stefan Wühl RSS

    EXCEL Sumproduct Functionality

      Guys,

       

      I'm trying to use Qlikview to solve a weighted average problem. As the example below,

      I would like to get an average GPA of (5*4+4*3+4*2+4*2+5*3)/(4+3+2+2+3)=4.5. How can i do it in QlikView?

       

      CourseScoreWeightWeight AVG
      Calculus54
      Discr. Math43
      English Lit.42
      Chemistry42
      Comp. Sci.53

       

      Thanks very much.