1 2 Previous Next 21 Replies Latest reply on Jun 3, 2017 9:10 PM by Morgan DUARTE

    Monthly targets to acheive for 3 consecutive months

    Morgan DUARTE

      Hi guys,

       

      I have a incentive scheme a bit tricky for me.

      If a customer achieve his monthly target for 3 consecutive months, then he gets its quarterly target.

       

      The monthly target is basically its yearly target /12 and the actual is updated daily for monitoring.

       

      Any idea how to implement this?

       

      Ideally I want to know in month 1 (if we are in Jan), how much he needs to do (remaining) to achieve its monthly target,

      then if we are in the month 2, and that he passed the month 1, how much he needs, to achieve its monthly target for the month 2. If he didn't pass month 1, the blank (Or even "Failed")

      then if we are in month 3 and that he passed the month 1 and 2, how much he needs, to achieve its monthly target for the month 3.

       

      Attached a simple example.

       

      Thank you

        1 2 Previous Next