Help in transforming the below excel calculation in Alteryx

Hi everyone,

I have encountered a complex problem. The below file contains a table. I need help in Calculating Y column. If you double click on any value of Y column the formula will come. I need help in transforming this excel formula in Alteryx. There are very large amount of data this is just the Dummy data. The main struggle I am facing is in SUMIFS calculations and Somewhere in the formula it's summing Y column which is the output column. I need this urgently Please help me with creating Standard Macro for this. You can load this file in Alteryx as input data and remove Y column through select. Please if anyone could solve this urgently.

Dummy Data.xlsx

Macros

Transformation

Accepted answers

All comments

OTrieger

@Riox078

What have you done so far to get it solve, have you developed anything in Alteryx?

Do you understand the formula in the excel file, as if you do or will understand it, it will open the door to what to do in Alteryx. So this is not an Alteryx issue, but the understanding of the excel formula. You have a nested IF formula, that should help you get it solved.

Riox078

I have fully understood the Excel formula but I am struggling at implementation of SUMIFS($X:$X,$S:$S,"X",$G:$G,"<"&$G11) - This part Where current BOM level needs to be greater then what's there in rest .

OTrieger

Good.

Then what you need to do is create the sumif value.

The you will have a total value that you can check if it is smaller than the other value.

Riox078

Bro if It was this simpler I could have solved it before posting in the community.

OTrieger

I will return to my original comment, figure out the excel formula and then you can figure out what is needed in Alteryx, it is not so hard, as you will need to group and sum your data based on the formula condition

Do you know why it is 5,136.00?

OTrieger

I promise to you that the difficulty is not with Alteryx but the calculation in excel how to get Y. When you will figure it out then you can work it out in Alteryx.

Riox078

Bro I didn't say that there a problem with Alteryx. I am able to fully understand what is required but the complexity is at implementing things in Alteryx. If you don't have a solution please don't reply with unnecessary things to this post. Peace out !

OTrieger

What is the complexity that you are facing, in which part of it do you need help?

OTrieger

You will be able to do it with the use of Summarize tool, and then apply formulas to get the end result.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703