Accumulative Count

[peterpater]

Crystal Version : XI
Tables :
- Employee Table (Emp_Name, Manager Name)
- Sales Table (InvoiceNum, Date, NumberofSales, ProductType). This table
contains data for the whole year.

Problem:
For the month of AUGUST (ONLY) we are running this new promotion for our tiny sales department.

- Salesperson to have the FASTEST 6-10 sales recieves a gift certificate of $50 (Category 1). Max Gift Certificates: 10
- Salesperson to have the FASTEST 11-15 sales recieves gift certificate of $80 (Category 2). Max Gift Certificates : 8
- Salesperson to have the FASTEST 16+ customers receives $100 gift certificate (Category 3). Max Gift Certificates: 5

Note:
-Sales incentive is ONLY specific to ProductType=TIRES.
-A salesperson who reaches the category requirement fastest
recieves the gift certificates.
------------------------------------------------------------
Select conditions: Month= August, ProductType=TIRES
------------------------------------------------------------
Report Fields:

Date
Salesperson
SalesCountPerDay
AccumulativeCountForAug
CategoryStatus
Check for Max Gift Certificates
------------------------------------------------------------

How do I calculate the AccumulativeCountforAug and the Check for Max Gift Certificates? I have tried
using running totals but I am not getting the right answer.

Please be advised I am a newbie to Crystal. I appreciate any help.

Thank you in advance.

 

[lbass]

Please do not post the same thread in multiple forums. I responded to your earlier thread. Plus this is the incorrect forum.

-LB