Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
BR
Hi BR,
if [PDM X Cemento] is a field name, try
sum(aggr( [PDM X Cemento]* Sum(Volumen)/Sum( DISTINCT TOTAL <Región> Volumen), Región, Gerencia))
Hi BR,
if [PDM X Cemento] is a field name, try
sum(aggr( [PDM X Cemento]* Sum(Volumen)/Sum( DISTINCT TOTAL <Región> Volumen), Región, Gerencia))
You R a Genius!!! Thanx