This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I believe a macro is needed to solve the problem below.
I have the following raw table data
The formula for coverage in Months is =INT((inventory+SUM(march:may))/monthly forecast requirement)
Monthly forecast requirement
Coverage in months
In Alteryx I need some help designing a kind of loop to solve this problem.
The loop would read the complete Column - "Coverage in months" and then pick the first lowest Number it sees. In the example above it would be Row 1 which reads 0. Then the loop should "+1" in the column Mar-19 for that particular Item.
Looking again for the formula for Monthly forecast requirement, we can see that even after pasting "1", the coverage in Months will still be 0 for this particular item.
So the loop runs again and looks again at the lowest value in the Coverage column and increase quantity by "1".
Another condition is the Total sum at the end of each month would be 1000.
After running the loop for Mar 19 then the loop would jump to the next column April 19
The output should look something like this. The results below are fake numbers