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

[CarliE · Accepted solution]

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,

[Christina_H]

This should do it.  I've also included a column indicating whether each requirement was possible.

[Rhitik_Krishnani]

Hello @Christina_H  

Thank your for your time and inputs.

it completely solved the use case.

One more help please,

Can you explain the difference between multi-row and multi-field tool with a practical use case possible?

I am really stuck in that.

Any input will be appreciated.

Thank you

~Rhitik Krishnani

[CarliE]

Hi @Rhitik_Krishnani 

The multi-field formula allows for multiple fields to be updated at once through a single function.

The multi-row formula goes row by row for the field you selected and performs the statement you type in the Expression window.

There are examples in designer as well if you click on a tool and click open example!

Best,

[Christina_H · Accepted solution]

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.

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

Both tools have sample workflows available in Designer, right click on the tool in the tool palette and select Open Example.

[Rhitik_Krishnani]

I posted another problem

No one replied

Can you help me please?

Here is the link:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/ALTERYX-SALES-USE-CASE/m-p/846058

Thank you

~Rhitik Krishnani