Tricky Formula/ Tool Question with Workflow

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.

Workflow Possible Formula Question.v2.yxmd

Workflow

Developer Tools

Input

Tips and Tricks

Custom Tools

Data Investigation

Accepted answers

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 : )

Workflow Possible Formula Question.v2.yxmd

All comments

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 : )

Workflow Possible Formula Question.v2.yxmd

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

yes it worked!! Thank youuu

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703