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]

Does this mean that 3 salespeople will win certificates for the month of August?

What does the Max Gift Certificates mean? Is that a maximum for the calendar year or?

Is "SalesCountPerDay" an actual database field or a summary?

Please show some sample data at the detail level.

-LB

 

[peterpater]

Max Gift Certificate means the max number of gift certificate allocated for one category.

Therefore, if the sales team is of 100 people, only the first 10 to reach category 1 criteria will recieve the category 1 gift certificate (which happens to be $50).

SalesCountPerDay is a summary of how many sales a salesperson has for the day, in the month of August.

Sample Data:

SalesPerson Date SalesCountPerDay AccumCountforAug
----------------------------------------------------
John Smith 02-Aug-06 3 3
John Smith 03-Aug-06 4 7
John Smith 04-Aug-06 0 7
Anthony King 03-Aug-06 1 1
Anthony King 04-Aug-06 1 2
Anthony King 05-Aug-06 3 5
....

In this case John Smith has already qualified for $50
Gift certificate.


Sorry about the post on the other forum, I was aware after I already posted.

Thanks.