Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question