How to divide the standard hours into the rows?

[Amrit_Sahoo]

I want to feel standard hours of 8 into rows for each emp id and date. Find the below table where I want to create standard hours in alteryx.

Emp ID	Date	Hours Charged	Standard Hours
1	23-07-2021	4	2
1	23-07-2021	3	2
1	23-07-2021	3	2
1	23-07-2021	2	2
2	23-07-2021	4	2
2	23-07-2021	3	2
2	23-07-2021	3	2
2	23-07-2021	2	2
3	23-07-2021	4	2
3	23-07-2021	3	2
3	23-07-2021	3	2
3	23-07-2021	2	2

Any help will be really appreciated.

Amrit

[Luke_C]

Hi @Amrit_Sahoo , what would you expect the final output to look like? I'm not sure I understand fully.

[atcodedog05]

Hi @Amrit_Sahoo 

As @Luke_C suggested can you please provide the sample input and expected output so that we can help you better 🙂.

[Amrit_Sahoo]

My Input would be 

Emp ID	Date	Hours Charged
1	23-07-2021	4
1	23-07-2021	3
1	23-07-2021	3
1	23-07-2021	2
2	23-07-2021	4
2	23-07-2021	3
2	23-07-2021	3
2	23-07-2021	2
3	23-07-2021	4
3	23-07-2021	3
3	23-07-2021	3
3	23-07-2021	2

My output would be 

Emp ID	Date	Hours Charged	Standard Hours
1	23-07-2021	4	2
1	23-07-2021	3	2
1	23-07-2021	3	2
1	23-07-2021	2	2
2	23-07-2021	4	2
2	23-07-2021	3	2
2	23-07-2021	3	2
2	23-07-2021	2	2
3	23-07-2021	4	2
3	23-07-2021	3	2
3	23-07-2021	3	2
3	23-07-2021	2	2

[christine_assaad]

Hi @Amrit_Sahoo 

Are you looking to summarize the data by EID and Date similar to the below? Cheers!

[Amrit_Sahoo]

My Input Looks Like

Emp ID	Date	Hours Charged
1	23-07-2021	4
1	23-07-2021	3
1	23-07-2021	3
1	23-07-2021	2
2	23-07-2021	4
2	23-07-2021	3
2	23-07-2021	3
2	23-07-2021	2
3	23-07-2021	4
3	23-07-2021	3
3	23-07-2021	3
3	23-07-2021	2

The expected output is 

Emp ID	Date	Hours Charged	Standard Hours
1	23-07-2021	4	2
1	23-07-2021	3	2
1	23-07-2021	3	2
1	23-07-2021	2	2
2	23-07-2021	4	2
2	23-07-2021	3	2
2	23-07-2021	3	2
2	23-07-2021	2	2
3	23-07-2021	4	2
3	23-07-2021	3	2
3	23-07-2021	3	2
3	23-07-2021	2	2

[Amrit_Sahoo]

@christine_assaad I don't want to use summarize tool since there are other dependants. I am looking for a solution by using multi row formula.

[Amrit_Sahoo]

My Input is till hours charged. I need the standard hours which is 8 per day to be equally divided to each row based on Emp ID & Date.

[Amrit_Sahoo]

Input

Emp ID	Date	Hours Charged
1	23-07-2021	4
1	23-07-2021	3
1	23-07-2021	3
1	23-07-2021	2
2	23-07-2021	5
2	23-07-2021	3
2	23-07-2021	3
3	23-07-2021	4
3	23-07-2021	3
3	23-07-2021	3
3	23-07-2021	2
3	23-07-2021	1

I would need the output to be as below:

Emp ID	Date	Hours Charged	Standard Hours
1	23-07-2021	4	2
1	23-07-2021	3	2
1	23-07-2021	3	2
1	23-07-2021	2	2
2	23-07-2021	5	2.67
2	23-07-2021	3	2.67
2	23-07-2021	3	2.67
3	23-07-2021	4	1.6
3	23-07-2021	3	1.6
3	23-07-2021	3	1.6
3	23-07-2021	2	1.6
3	23-07-2021	1	1.6

[Luke_C]

Hi @Amrit_Sahoo 

Here's an example, I used summarize to get the count of records for each ID and use to split the 8 hours.