Anyone have any ideas on how to solve this? Attached is the sample workflow I created but it doesn’t work as soon once you add another employee with the same week ending period so I’m open to new suggestions.
the problem I’m trying to solve: I need to pro-rate hours that overlap two months in any given week.
example: if you have 35 estimated hours for week ending 4/3/2021, then 20 of the hours should move to the prior period, 3/27/2021, since 4 of the days falls into March. the remaining 15 hours should stay in the current period.
