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.