add rows below based on the req calculated

[moinshaik]

I have a input data with the name and the week wise details as below.

Name	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8
A	50	21	120	123	300	322.0	123.0	345.0
B	60	22	70	340	200	322.0	322.0	111.0
C	70	60	50	234	350	233.0	257.0	222.0

and I need the output as below where in first it should calculate the R weeks which is requirement i.e every week needs to be divided by 40 and rounded to nearest digit. the formula is round(weeks/40) this applies to all the week columns and then based on all the weeks calculated wherever we has the highest requirement those no. of rows needs to be created. If the requirement is zero for all the rows then the minimum of 2 rows should get created as the week hours might be below 40 because of which it is coming zero. Please find the below output which I am expecting with the R weeks calculated and the rows created with the name.

Name	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8		R Week 1	R Week 2	R Week 3	R Week 4	R Week 5	R Week 6	R Week 7	R Week 8
A	50	21	120	123	300	322.0	123.0	345.0		1	1	3	3	8	8	3	9
B	60	22	70	340	200	322.0	322.0	111.0		2	1	2	9	5	8	8	3
C	70	60	50	234	350	233.0	257.0	222.0		2	2	1	6	9	6	6	6
A
A
A
A
A
A
A
A
A
B
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
C
C

[jamielaird · Accepted solution]

Hi @moinshaik ,

(I've flagged your question to be moved to the Designer Discussions forum.)

Here's a workflow that achieves the result you are looking for:

Spoiler

Hope that helps and let me know if you have any questions.

Jamie

[moinshaik]

Awesome this is what I am looking for. Thank you so much. Also is there a way where we can updated the requirement hours like below. It needs to be updated for all the generated rows

Name	Week 1	Week 2	Week 3	Week 4
A	50	21	120	123
B	60	22	70	340
C	70	60	50	234
		If it is less than 50 then divide the requirement by 2. otherwise it should be 45
A	25	10	45	45
A	25	11	45	45
A	0	0	30	33
A	0	0	0	0
A	0	0	0	0
A	0	0	0	0
A	0	0	0	0