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
Solved! Go to 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.
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
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
Hello Shanker,
Would you not mind to attach the workflow here.
Thanks
AJAY
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