Dividing an input number based on months available

[shravanvijayaprasad]

I'm a little confused on how to achieve this. It would be great if someone can help me with this. I have a table

Month	Name
1	sss
1	tt
1	uu
1	vv
1	ww
2	ss
2	tt
2	uu
2	vv

I want to get an input from user (a number say 100) and based on the number of months available (here 2), I want to split it up for the two months. The complexity comes because I just want to populate the first row of each month with the divided value (50) Example output is below

Month	Name	Value
1	sss	50
1	tt
1	uu
1	vv
1	ww
2	ss	50
2	tt
2	uu
2	vv

[fmvizcaino · Accepted solution]

Hi @shravanvijayaprasad ,

Attached is an example showing how to do it.

Let me know if this works for you.

Best,

Fernando Vizcaino