>>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'.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
