Finding amounts that sum to zero

[jannis2021]

Hi. 

I have several data sets where I would like to build a workflow that identifies amounts that SUM to zero and segregate them from amounts that do not SUM to zero. Prior to Alteryx I would use Excel's solver functionality to accomplish such tasks. Is there a way to replicate this functionality in Alteryx? I attempted to use the Optimization tool, but am not familiar enough with the syntax to build out the parameters correctly. Can anyone assist?

Example data:

694,494.34	1
(77,749.62)	1
207,256.03	1
(1,517,382.72)	1
615,632.35	1
77,749.62	1
100,000.00	0

[EstebanDaMan]

Hi Folks,

I was able to create the workflow based on @jannis2021 last post. All credits to @jannis2021 for this wonderful solution.

[srikar235]

Hi @estebandaman and @jannis2021.

Is there is any way to do this for different groups of data(based on a key column) in a single dataset.

For Example my data looks like

Key	Amount
1	3
1	4
1	2
1	10
1	-9
2	4
2	5
2	-9
2	12

And my desired output is 

Key	Amount
1	10
2	12

Thank you.

[OllieClarke]

Hi @srikar235 

I think in your example you just want to sum the Amount column, grouped by the Key column

[srikar235]

Hi @ OllieClarke

Sorry for not being clear

My input has 20 columns other than key and amount

Key	Amount	Invoice number
1	3	1
1	6	4
1	10	5
1	-9	6
2	4	7
2	5	8
2	-9	9
2	12	10
2	13	11

And my desired output is 

Key	Amount	Invoice number
1	6	4
1	10	5
2	12	10
2	13	11

 Thank you

[srikar235]

Hi @OllieClarke

Sorry My input is 

[OllieClarke]

Hi @srikar235 

Here's a solution based on @jannis2021's previous work

[srikar235]

Thank you so much @OllieClarke.

I was stuck at this for last two days. you really helped me a great time.

Thank You

[BS_THE_ANALYST]

@OllieClarke just used this optimisation solution for another problem! Thanks for this 👌