Help in transforming the below excel calculation in Alteryx

[Riox078]

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. 

[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.