Using Multi Row/Multi Field Formula to resolve the issue

[ajanayak]

Hello Team,

Please help me to resolve the difficulties which I am facing in one of my delivery where I need to use Multi Row/Multi Field formula to get the result, I am stucked to move forward, Please help me, Thanks in advance.

Any help would be appreciated.

Thanks

AJAY

[mceleavey · Accepted solution]

Hi @ajanayak ,

If you want to know more about how to use the multi-row formula I suggest the following help article:

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

I would also strongly recommend jumping in to the Learning Paths section of the Alteryx Academy:

https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117

You can also try the interactive lessons which has a specific one for multi-row formula:

https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872#done

Once you have gone through these, and are still unable to build this then I suggest you reach out with the specific problem you are having.

Thanks,

M.

[ShankerV]

Hi @ajanayak 

Please find the expected output.

K4 = (J4-K3)+K2

Many thanks

Shanker V

[ShankerV]

Hi @ajanayak 

Step 1: Input

Step 2: 

Step 3: 

Many thanks

Shanker V

[ShankerV]

Hi @ajanayak 

Step 4: Sort tool

Step 5: 

IF [F11]="Inventory: 4PL"
THEN tonumber([Row-4:Value])-tonumber([Row-2:Value])+tonumber([Row-1:Value])
ELSE [Value]
ENDIF

Step 6:

Many thanks

Shanker V

[FinnCharlton]

@ajanayak ,

Here is a way to replicate your output:

[ShankerV]

Hi @ajanayak 

Adding the dynamic tool at the end will help the column name to take from the first row.

This is optional based on how you need to format the output.

Many thanks

Shanker V

[ajanayak]

Hello Shanker,

Would you not mind to attach the workflow here.

Thanks

AJAY

[ShankerV]

Hi @ajanayak 

Please find the attached workflow.

[ajanayak]

Hello Shaner,

Is it necessary to keep the first row contains data, At the same time solution doesnot fit if my dataset changes with one more set of data, Please have some time and look into the data, Data is not appearing perfect for calculated field that is INVENTORY :4PL

Any help would be highly appreciated.

Thanks

AJAY