Wrong total in pivot table

[pgalvezt]

Hello, I'm Having a different result from the pivot table. I have had reading about this. I think I have to use the aggr advanced function.

But Doesn't work

19,462,283
6,109,388
2,342,810
1,062,468
-271,798
-271,798
-253,340
29,810,800

My Formula is: the sum should have

28.180.013

and not 29810800

=(Sum(If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)

Thank you!

[hic]

I don't think you need the aggr function. I think the problem is that you divide the Sum(...) with Divisor, which is an unaggregated number. This causes problems in all cases where there is more than one possible value of Divisor. You should either move the division into the Sum(...) or you should divide with Avg(Divisor).

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/03/the-only-function

HIC