10 Replies Latest reply: Oct 12, 2017 11:14 AM by Darrell Tobin RSS

    Sum # of tasks between 2 date ranges

    Rebecca Parkinson

      Hi

       

      I need to sum the number of tasks a person created between 2 dates, then assign them points for every 100 tasks created. For tasks created between 15/09/2017 and 30/09/2017 (inclusive) I want to award 5 points for every 100 tasks, and between 01/10/2017 and 15/10/2017 (inclusive) I want to award 10 points for every 100 tasks created.

       

      I assume set analysis is required?

       

      Thanks in advance!

      Becs