You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Time entry rule fast formula

edited Jul 14, 2020 2:17PM in Workforce Management 2 comments

Content

Hello,

I am trying to create some time entry rules that limit the number of overtime hours entered. The requirement is to cap the number of overtime hours at 128 hours with a reference period of 4 months. In 4 months you cannot log more than 128 hours.

I have used a seeded Oracle formula (attached) and created new time category that include only overtime. I have set a limit number of hours and it worked. If overtime time types were more than that limit the system threw the error. But I don't know how to reference this to a 4 month period. I have only per day or per time card option. Do you know what and how can I modify the formula to apply this maximum limit of hours for a 4 month period reference and throw an error only if in the last 4 months

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!