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 am trying to implement this logic in Alteryx and not able to get perfect output as per my requirement.
Appreciate your help in this.
Let's say I have forecasted data for 13 weeks as below:
Now based on my inventory and backlog orders I have to adjust this forecast.
For example if Total Adjustment = 20 (means I have 20 backlog orders), my forecast will change to:
But if the total adjustment = -50 (I have 50 products in my inventory) then output should be as follows
Below is the explanation to come with the output above
Doing this in code is easy, we can write for or while loop, but I am unable to achieve the same in Alteryx.
Please let me know in case of any queries.
Looking forward for some answers.
Didn't get you?
Here's a possible solution that wouldn't require an iterative macro. It still may require a few tweaks, but this should, at least, get you started.
Sorry for not including any explanation... it's late in the day and heading home. If you have questions, let me know and I'll respond when possible.JimmyTeknion Data Solutions