Search
Search

# Wrong Totals at Drilldown

Hello Experts,

This is my problem: when I run a query at maximum level (Customer, Invoice, Item) it works fine (calculations and the whole totals)

Customer / Invoice / Item / Units / Price / Total

33 / 9003 / 388 / 60 / 150 / 9,000 <- detailed total is well calculated 60*150=9000

33 / 9003 / 23272 / 24 / 150 / 3,600

33 / 9003 / 30767 / 36 / 150 / 5,400

-

/ 120 / / 18,000 <- Total Invoice 9003 (is summarized correctly)

33 / 9004 / 930 / 144 / 130 / 18,720

33 / 9004 / 4685 / 14 / 99 / 1,386

33 / 9004 / 4696 / 6 / 127 / 762

-

/ 164 / / 20,868 <- Total Invoice 9003 (is summarized correctly)

/ 284 / / 38,868 <- Total Customer 33 (is summarized correctly)

But when I remove drilldowns to see totals by Invoice or Customer, figures are wrong:

Customer / Invoice / Units / Price / Total

33 / 9003 / 120 / / 54,000 <- WRONG, should be 18,000, what the query does is 120*450(price summation)=54,000

33 / 9004 / 164 / / 58,384 <- WRONG, should be 20,868

Customer / Units / Price / Total

33 / 284 / / 228,906 <- WRONG should be 38,868

Price is: Calculate Result As… Suppress Result

Total is: Calculate Result As… Summation

How can I fix this total calculation problem? We need to see the query at any level. Our BW version is 3.5 Thanks for your help in advance.