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




      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