Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Group Sum Problem
Message
Information générale
Forum:
ASP.NET
Catégorie:
Rapports
Divers
Thread ID:
01508279
Message ID:
01508398
Vues:
32
>>>>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.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform