Re-create allocation solution using Alteryx maybe using aN Iterative macro

[anayet1988]

Hi Everyone,

I am having trouble recreating an excel formula using Alteryx due to it's loop nature.

I have attached the Excel file.

Please note the following:

- Columns A, B and C are fixed and can not be changed and it has to be in that order

- Columns D and E are simple look up of the "Look up table" tab

- Columns F and G are what needs to be recreated in Alteryx.

Simply put that in Alteryx the input will look like columns A to E. (You can copy these columns into the canvas as a text input to make it simpler".

The problem I am having is trying to recreate the sumif formulas in columns F & G that take column H into account.

I think an iterative macro should solve the problem.

Any help will be greatly appreciated.

Thanks

Anayet

[Treyson]

Hello @anayet1988,

At first I thought this would be a solution for the multi-row tool. However, the more I think about it, you may need to create a batch macro to solve this problem. Shameless plug article I wrote. 

Essentially, you are going to have to run the process once for every row. Since you need to have your current row to check against every row that has come before it, you are going to have to create some sort of "in" statement for each record. I was going to build a demo for this, but when I was looking through your workbook, I was thinking maybe I don't understand how your workbook works. If you look at F392, why does it not equal 84,500.00?