wrong subtotals in pivot table

[anitamanders]

Hello,

I get wrong subtotals in pivot table in row " totaalbedrag inc. korting"

Can someone help me out?

Enclosed file.

Thanks

Anita

[Anonymous · Accepted solution]

Anita,

It seems like your expression is a little bit wrong.

Currently you have this:

sum(Factuurregel_regelbedr) -

(sum(Factuurregel_regelbedr)/100)*(sum([Factuurregel_perc-krt]))

However, if you change to this I think your totals should match:

sum(Factuurregel_regelbedr) -

(sum(Factuurregel_regelbedr*[Factuurregel_perc-krt])/100)