Forum Discussion
Post ProdigyMoving scheduled work hours
Community SupportHi pawelj795 ,
To achieve these two requirements, it seems to be missing something about logic definition.
For example, what's the definition of overdue? Since 60 hours of work were scheduled to do on 20 March. But it wasn't done. How to define it like over 50 or something else?
In addition, what's the definition of moving these hours to be scheduled today? How to allocate the remaining time because there are three products in your dataset. If the previous day is always overdue, the work time will accumulate instead of just the weekends work time shows.
Best Regards,
Yingjie Li
pawelj795v-yingjl
Hi, thanks for weighing in.
I'm aware that probably I didn't explain it very well.
1. Overdue -> I meant that if any work were scheduled before today (how many days elapsed don't really matter)
The point is if that work weren't done, it should be done asap, which means scheduled on today as a reminder.2. Yes, I want to accumulate these hours.
Let me show a 2 simple examples.
1. Today is 24th April
In my basic model without any calculations or adjustments, I have scheduled below work hours.
- On 20th March 60 work hours were scheduled
- On 4th April 30 work hours were scheduled
- On 24th April 10 work hours were scheduled
These hours weren't done!If these work hours would be done then they would disappear by my SQL database.
Now, in my desired model I want to sum these hours, which means that on 24th April(today) I should have 100 work hours.2. Example about weekends. (future)
Today is 24th April
In my basic model without any calculations or adjustments, I have scheduled below work hours.
- On 8th May 20 works hours were scheduled- On 9th May 10 works hours were scheduled (Saturday)
- On 10th May 30 works hours were scheduled (Sunday)
In my desired model should be 60 works hours on 8th May (before the weekend).
I hope this would help you understand my problem.