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:
01508498
Views:
31
>>>>>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 !
>>>
>>>Exactly.. There should be seven. Sum the AlertQuantity column for part '28655A'.
>>
>>Hi Kevin, how are you "summing" the AlertQuantity - cos it sounds like it's "counting" instead of "summing" - personally I always create my own variables and increment / reset them in formula fields it gives you a lot more control.
>
>I added a Running Total field, resetting it when the Part Number changes.

Reset it on change of territory - you will then get 7, another way is to reset it on change of group "PartNumber" - I've tried it and it works fine
Regards,
Peter J. Kane



Pete
Previous
Reply
Map
View

Click here to load this message in the networking platform