We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Iterative macro doesnt add up values safety stock calculation

zkostaws
5 - Atom

Hi,

 

I am trying to create a workflow where i can calculate and display safety stock levels. It is almost ready, but I need to solve one challenge. 

I need to add a macro to keep on adding the boxes until one of the critirias is met ( packaging level should be sufificient for more days than the lead time)

 

 

I need iterative macro for that ( it adds an extra box to the 'recommended order' until the 'stock is sufficient'  for longer time than the average lead time. 

 

It is not adding anything. 

 

I added a filter here:  when the condition is met it outputs the data

if it doesnt it should add +1 to the 'how many to order' collumn

 

I wish in first iteration ' how many to order' column will be updated and the formula tool will recalculate all the other fields -    including [stock sufficnet for days after receivng]) .

 

then it flows to the filter and again if condition is met it outputs the data if not we get another iteration   until criterias are met for all records...

  

 

zkostaws_0-1669026144144.png

thanks for help!

1 REPLY 1
zkostaws
5 - Atom

Ok I solved it - by changing the iteration output in macro setting to the LOOP output instead instead of normal output :)

zkostaws_0-1669037853573.png

 

Labels
Top Solution Authors