formula claculation in query is not summing correctly when details are remo

[Former Member]

have a report that totals 2 columns together and is at the work center level. when I remove the details the totals are wrong but when I show them it comes over correctly. Here is the scenario

work center column a column b sum a+b

XXX 2 2 4

the details however bring in 3 and 5 & 8 for columns respectively. Why would the work center level be wrong. do I need to do anything special in my formula?

[Former Member]

resolved

[Former Member]

Hi,

Are the KF are non cumulative ones?

With rgds,

Anil Kumar Sharma .P

[Former Member]

they are set to total standand value and the cumalative is not checked

[Former Member]

Hi,

Do you mean the<i> calculate result as propety</i> set to standard Deviation for those KF ? If so , we can not expect as how it would be if we select <i>summation</i> for <i> calculate result as propety</i> .

With rgds,

Anil Kumar Sharma .P

[Former Member]

no what I mean is if I bring in work center and confirmation the total says 8 but when i remove confirmation the total says 6 it should still be 8.

[Former Member]

Are you getting the correct figure for column a and column b when you remove confirmations.

regards.

[Former Member]

Hi MICK,

the formula is calculating column A + column B as you have mentioned, and in your example, it is 2 and 2 its showing 4.

Regards.

[Former Member]

I am saying it should be what the details sum to. It is for some reason not adding up all the values