Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Required Help in Logic Building

Rhitik_Krishnani
8 - Asteroid

Hello Community,

I hope you all are doing well.

 

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

Formula_Doubt.PNG

 

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

 

 

6 REPLIES 6
CarliE
Alteryx Alumni (Retired)

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,

Carli
Christina_H
14 - Magnetar

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

Christina_H_0-1636645642711.png

 

Rhitik_Krishnani
8 - Asteroid

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
Alteryx Alumni (Retired)

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,

Carli
Christina_H
14 - Magnetar

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
8 - Asteroid

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

Labels