Running total - PTO Days remaining
Employee has 20 days at beginning of PTO time period Employee has multiple time-off requests throughout the period. How do I create a running total field [REMAINING DAYS] off of [DAYS ALLOWED] field...
Forum Discussion
You need a formula field on the Employee table that will subtract the number of approved days that year from their Yearly PTO.
So the components are
Number of days from the request
Requests from this year
Request Status is Approved
One more factor is the Field Type. Are you tracking Numbers or Durations? If you are going to use the info in other calculations, I would go with Durations.
------------------------------
Don Larson
------------------------------
So the components are
Number of days from the request
Requests from this year
Request Status is Approved
One more factor is the Field Type. Are you tracking Numbers or Durations? If you are going to use the info in other calculations, I would go with Durations.
------------------------------
Don Larson
------------------------------