8 Replies Latest reply: Jan 20, 2014 6:14 PM by Jacob Neroth RSS

    Arithmetic Operation between two diff Aggr and changing the partial sum

    Jacob Neroth

      Hi All,

      I have the following table

       

      Column1Column 2Column3Header 4Header 5
      A10100
      1.666667
      B20200
      6.666667
      C30300
      15
      Total
      20
      600
      20( Expected:
      23.33333
      )

      Column 2 : is a SUM(AGGR(SUM [.....])))

      Column 3 : is a Average of some value AVG(AGGR(AVG[...]))

      Expression in Header 4 : (Column 2 * Column 3)/(Total of Column 3 )


      So my problem is in Header 4 : the total basically shows me Column 2 * Column 3 /Column 3

      but what i was is the sum of the values in Header 4


      Can anyone help me out here?


      Thanks,

      Jacob