How to generate increment row based on value of another column

Hi Guys,

I would appreciate some help with this. I want to generate rows (increment date + 1) based on the value of another column. The value column in this case max of 50. if >50 create a new row and increment date by 1.

e.g. A is split to 6 rows, B is left, C is split to 3, D is left, E is split to 2 rows (75 = 50+25)

i tried using the generate rows tool. but hit a snag.

Workflow

Data Investigation

Accepted answers

paulfound

Hi @EJ_Alt

Nice little challenge this.

EJ_ALT.yxmd

All comments

Ben_H

Hi @EJ_Alt,

I did it with generate rows and a couple of multi row formulas, I have a feeling there's a simpler way but this is what I did -

Hope that helps!

Regards,

Ben

Generate Rows.yxmd

EJ_Alt

Hi @Ben_H , thanks for your solution, its almost right. Is it possible to make the max value in the value column no more than 50? see my final output in the original question

e.g. Person A will be (300/50), 6 rows of 50, Person B is OK, Person C is 3 rows of 50, Peron D is OK, Person E would be 1 row of 50 and 1 row 25.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703