How to add to another row the additional amount and keep the same lines as in the original

Question

Hello community

I am difficulties to apply following logic(see sheet input).

* if total hour/name/day is less than 7.5 then keep the original hours
* if total hour/name/day is between 7.5 and 10 then for the day apply 7.5
* if total hour/name/day is more than 10 then put the difference to another row for another day for the same person

do you think this is possible? I put output sheet as a result I'd like to see

thank you

help from alteryx.xlsx

Nazik_Ghukasyan · Answer

hi @DawnDuong thanks for your try, I am not sure it is giving the right result. can you please see my response with the conditions as well as updated file for your reference

thank you much for your help

Nazik

Nazik_Ghukasyan · Answer

hi @ArtApa thanks for your email and sorry I was OOO

please see my responses below:

1. if the total hours spent by a person for a day is less than 7.5 then there is no change

2. if the total hours spent by a person is between 7.5-10 then we apply for total hours 7.5 (the difficultly is when there are several lines for the same day let's say 3H for X + 2 for Y + 4.5 for Z)

3 if the total hours spent by person is more than 10 for example is 12, than we should apply for that day 7.5 (as point 2) but the difference (12-7.5=4.5) to the next day for the same person.

Sorry I attach the new file as there was a small mistake.

help from alteryx.xlsx

DawnDuong · Answer

Hi @Nazik_Ghukasyan

What you asked for is possible. To get the desired output format, you need 1 transformation step. Hope this helps.

Dawn.

Revised hours.yxmd

Revised hours.PNG