Tricky Formula/ Tool Question with Workflow

[Cferrer6]

Hi Alteryx Community. 

I have a tricky problem that i need help solving. I have a input report that has multiple "orders" with in each order there can only be equal or less than number of "deployment fees" than Clover Flex Gen's. If there are more i want to use alteryx to zero them out. Attached is a flow that completed that task but only for a single order. How can i complete the task if there are multiple orders in the data set. Any help is greatly appreciated!

Thank you in advance. 

[atcodedog05 · Accepted solution]

Hi @Cferrer6 

It might be something like this. I am still unclear with your logic.

If this doesn't work please explain the logic and provide the expected output.

Hope this helps : )

[ChrisTX]

Use a batch macro.  Pass in each Order number.

Watch the videos on this page for Batch macros: https://community.alteryx.com/t5/Videos/Video-Training-Index/td-p/45161

Chris

[Cferrer6]

yes it worked!! Thank youuu

[atcodedog05]

Happy to help : ) @Cferrer6 

Cheers and have a nice day!