AnsweredAssumed Answered

Selecting value ranges from a record count

Question asked by mcampa0902 on Dec 17, 2014
Latest reply on Dec 18, 2014 by user19752

I´m working on two rewards programs for my employees.

 

One of them awards points by level. Level is determined by the number of transactions made by employee.

For example:

 

     If employee made 22 transactions, he gets:

     3 points for each of first 5 transactions (15 point total)

     4 points for each of the following 5 transactions - 6 to 10 - (20 points total)

     5 points for each of the following 5 transactions - 11 to 15 - (25 points total)

     6 points for each transaction above 15. (42 points in this example)

     Employee gets in total 92 points.

 

In the other program, employees get a reward (gift) for every 5 transactions.

     In this case i need to keep track of gifts redeemed.

 

I´d appreciate any help.

Outcomes