Need help with dividing the week wise amount in to multiple resource

Question

Need help with dividing the week wise amount in to multiple resource dividing by 40 for the first week and dividing by 45 for the other weeks. Please see the below input and the expected output. In the case the week amount is less than 60 then it should be divided in to 2.

Input:

NameWeek 1Week 2Week 3Week 4Week 5A316422499711766A     A     A     A     A     A     A     A     A     A     A     A     A     A     A     A     A     B50608090100B     B     ..etc

Desired Output

NameWeek 1Week 2Week 3Week 4Week 5A315.9421.9499.4711.4765.7A4045454545A4045454545A4045454545A4045454545A3645454545A4045454545A4045454545A4017454545A 45454545A 45454545A  494545A   4545A   4545A   4545A   4545A   3645A    45B50608090100B2530404040B2530404040B   1020

KarolinaRoza · Accepted Answer

Hi @moinshaik ,

I prepared workflow for you which I hope will be useful. It is not completed by I hope it will be useful and you will be able to continue with it.

It still require some manual intervention but I do not have idea how to make it more efficient. Maybe any of Community Member will be able to advice.. ?

So, in the workflow I prepared logic for rows generation for each week (week1 has slightly diff logic, week 2-3 are the same), you would need to copy the container and adjust column names for next weeks (it is marked in red containers it the workflow).

Let me know if it is helpful and if you need assistance with continuing with your problem.

BTW are you sure about the split for 2nd week..

Regards,

Karolina