Required Help in Logic Building

Rhitik_Krishnani

Hello Community,

I hope you all are doing well.

I am attaching a screenshot of a use case for your reference

In the following use case what I have to achieve is,

Based on FG Code and RM CODE

Suppose, Requirement is 6 and and Possible is 21 , so order can be completed.

After completion, balance will be 15.

Then again, requirement is 6, possible is 15, so order can be completed.

After completion, balance will be 9 and so on

I want to build this logic.

Moreover, this is for one FG CODE and RM CODE

There are many FG CODES and each FD CODE has many RM CODES

I hope I made the use case clear. Please help

Thank You

~Rhitik Krishnani

Workflow

Accepted answers

CarliE

Hi @Rhitik_Krishnani ,

Attached is a solution. I made the assumption that we will have the first possible value.

Please mark as a solution if this solved your problem to better help other members on the community.

Thanks,

Required Help in Logic Building.yxmd

Christina_H

No problem, if it helped it would be great if you could mark it as a solution.

A multi-row tool applies a formula to a single field with reference to previous or following rows as in this case. I've used it to set the value of FG possible based on the possible and req values on the previous row.

https://help.alteryx.com/20213/designer/multi-row-formula-tool

A multi field formula is used to apply the same formula to multiple fields, e.g. if I had a total field and breakdown into categories on a single row I could convert each category to its percentage of the total.