Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group Sum Problem
Message
General information
Forum:
ASP.NET
Category:
Reporting
Miscellaneous
Thread ID:
01508279
Message ID:
01508295
Views:
23
>Ok, I have this data:
>
>
>CompanyName            ContractNumber Territory  Part_Number AlertQuantity MAS90Quantity
>---------------------- -------------- ---------- ----------- ------------- -------------
>EXXONMOBIL RESEARCH    100309         PAS        28655A      2             3            
>SOURIAU USA, INC.      100396         PAS        28655A      1             3            
>PEARSON VUE            100519         PAS        28655A      1             3            
>PEARSON VUE            100519         PAS        28655A      1             3            
>PEARSON VUE            100519         PAS        28655A      2             3            
>NASSCO                 100029         SVC        28655A      1             1            
>NASSCO                 100029         SVC        28655A      1             1            
>NASSCO                 100029         SVC        28655A      1             1            
>NASSCO                 100029         SVC        28655A      1             1            
>
>
>I have grouped the report by Territory, Part_Number, and ContractNumber. I created a running total field on Part_Number and had it reset on the change of the Part_Number group.
>
>When the report runs, I get:
>
>
>CompanyName            ContractNumber Territory  Part_Number AlertQuantity MAS90Quantity
>---------------------- -------------- ---------- ----------- ------------- -------------
>EXXONMOBIL RESEARCH    100309         PAS        28655A      2             3            
>SOURIAU USA, INC.      100396         PAS        28655A      1             3            
>PEARSON VUE            100519         PAS        28655A      1             3            
>PEARSON VUE            100519         PAS        28655A      1             3            
>PEARSON VUE            100519         PAS        28655A      2             3      
>
>															 5
>


>You can see that there are a total of 7 for territory PAS, yet the running total is coming up with 5. I have no clue how to 'debug' this. The data's correct, and the running total field is very simple.
>
>Some direction would be nice.
>
>Thanks


Hi Kevin, I can only see five for PAS !
Regards,
Peter J. Kane



Pete
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform