0 Replies Latest reply: Apr 11, 2013 1:45 PM by user537680 RSS

    Fast Formula to calculate absence availability

    user537680
      In Rel 5 Fusion HCM

      I need create a Fast Formula to attach to absences in order to calculate how much time an employee has left to take. However, the client has a very unique way this is done. They are NOT using hire date or a calendar date. Instead, it is calculated based on the amount of time taken in the last 12 months, from the date of the new request for absence.

      For example, an employee requests time off for 5/1/2013, so the available balance needs to look back at the time taken in the last 12 months from 5/1/2013. The employee then again requests time off 8/15/2103, so it should look back 12 months from 8/15/2103.

      Sample below:

      Date      Taken      Balance
      DOH 3/1/13 6
      4/1/2013     2     4
      5/1/2013     1     3
      9/1/2013     3     0
      12/31/2013     0 0
      3/1/2014     0     0
      4/1/2014 0 0
      4/2/2014     0     2
      4/8/2014 1     1
      5/1/2014     0 1
      5/2/2014 0     2
      6/1/2014     0 2
      7/1/2014 0     2
      8/15/2014 1     1
      9/1/2014     0     1
      9/2/2014     0     4