3 Replies Latest reply on Dec 18, 2014 3:28 AM by user19752

    Selecting value ranges from a record count

    mcampa0902

      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.