11 Replies Latest reply on Apr 11, 2018 12:58 PM by Jim Dehner

    Running Calculation

    Nisha Mistry

      I am trying to create calculation so it is a running total of the Active Headct. I would like the total to roll over for 4 quarters. Since the total is rolling over for 4 quarters, 25% of the total will be accounted for in each quarter. For example: if the head count is 10 in quarter 1; 2.5 will be counted for quarters 1,2,3 and 4. If the total head count is 10 in quarter 3; then 2.5 will count for quarters 3,4,1,2. I've attached an example to use.