topic Re: Subtotal Calculation Not Correct in QlikView

Subtotal Calculation Not Correct

Anonymous — Tue, 17 Nov 2015 19:47:10 GMT

Can someone help me figure out why the subtotal in this pivot chart is not correct? The lines below it are correct but the subtotal should be 837 instead of 800 and I can't see what the problem is.

Re: Subtotal Calculation Not Correct

sunny_talwar — Tue, 17 Nov 2015 19:53:26 GMT

What is your current expression that you are using?

Re: Subtotal Calculation Not Correct

swuehl — Tue, 17 Nov 2015 20:02:36 GMT

For example, if your column(9) total is in fact a little larger than shown (i.e. the shown total of 0.4651 is rounded), this might explain the issue.

Also double check the other column values if they are rounded.

Re: Subtotal Calculation Not Correct

Anonymous — Tue, 17 Nov 2015 20:02:56 GMT

It's there in the screenshot - Take column 3, subtract column 9, multiply the result by column 1. It works fine except for the total line.

Re: Subtotal Calculation Not Correct

Anonymous — Tue, 17 Nov 2015 20:04:24 GMT

I thought it might be rounding as well but the lower lines are only rounding to the nearest dollar. If the total line is correct, then it's rounding the nearest hundred. But I don't see why or how it would do that.

Re: Subtotal Calculation Not Correct

sunny_talwar — Tue, 17 Nov 2015 20:04:44 GMT

Hahahaha, I feel embarrassed now. Just missed it totally

Re: Subtotal Calculation Not Correct

swuehl — Tue, 17 Nov 2015 20:08:21 GMT

Seems to me like number format for col3 and col9 are set to 4 decimal places on number tab. Correct? Try increasing the decimal places shown.

Re: Subtotal Calculation Not Correct

Anonymous — Tue, 17 Nov 2015 20:11:30 GMT

That doesn't make any difference.

Re: Subtotal Calculation Not Correct

swuehl — Tue, 17 Nov 2015 20:14:29 GMT

I was more interested in seeing col3 and col9 with more decimal places.

Re: Subtotal Calculation Not Correct

sunny_talwar — Tue, 17 Nov 2015 20:16:09 GMT

I think Stefan is right, We are just seeing upto 4 decimal points and the calculation could be taking place upto 14 decimal points here

Re: Subtotal Calculation Not Correct

Anonymous — Tue, 17 Nov 2015 20:16:13 GMT

Re: Subtotal Calculation Not Correct

Anonymous — Tue, 17 Nov 2015 20:17:06 GMT

But that still doesn't explain why the detail lines are correct but the total is not.

Re: Subtotal Calculation Not Correct

sunny_talwar — Tue, 17 Nov 2015 20:18:58 GMT

So it does make sense then

(0.46608409-0.46512778) * 837005 = 800.436251550013

Re: Subtotal Calculation Not Correct

swuehl — Tue, 17 Nov 2015 20:19:51 GMT

This is what I get, manually calculated with the precision shown:

800,43625155

Seems ok to me.

Re: Subtotal Calculation Not Correct

Anonymous — Tue, 17 Nov 2015 20:23:42 GMT

Oh wow, I never would've thought the precision would change the result that much. Thanks guys! (I'd mark both of you correct it would let me)