2 Replies Latest reply: Jan 15, 2013 7:34 PM by Berenice Guerrero RSS

    To Calculate Sum of Rows with aggregated expression

      I want to calculate the Total sum by Región of [PDM X Región 2] Field

       

      I have this:

       

      [PDM x Región 2] = [PDM x Cemento] * [Volumen %]

       

      And I want to get the total sum = 2.47

       

      aggregation.PNG

       

      My [PDM x Región 2] Expression is: [PDM X Cemento]* Sum(Volumen)/Sum( DISTINCT TOTAL <Región> Volumen)

       

      I've tried using the sum(aggr(sum [PDM x Región 2] , Región, Gerencia)) and doesn't work

       

      Can anyone help me, please

       

      Thanks a lot

      BR