Checking summation for 0 for 5 above and below 5 rows

ferha_jafri

Hello Experts I am not able to find a solution for this in normal alteryx discussion so thought to post here,

Not sure how to achieve this, I have a scenario in which I have to take those rows who has Code as "ABC- " comment as "Int" in the final output, then compare these rows income value for which Code is "ABC-" and Comment is "Int" with the above and below 5 rows i.e. total 10 rows, to check these rows summation for same ID come to 0, rows can be 1,2,3,4,5 any no. of rows . In the excel attached , take eg of 200 Income whose summation comes for 1+2+4 row as -200 so it will reverse this amount and this row will not be considered in the final output. Hope to find a solution as I did not find it in normal alteryx discussion.

Thanks in advance. 

SampleforReverse.xlsx

apathetichell

I'm very sorry but could you take a bit more time to explain what exactly you are looking for? Take for example your data that you uploaded.

I can tell you which numbers are in columns ABC- and column INT and I can get a sum of any 11 rows (i.e. 5 rows with the same value before and 5 rows with the same value after) are you asking to identify where that sum is zero?  Are you saying any combination of numbers in this group can be zero? How would one allocate this if multiple zero combinations were possible? (say row -3, row -2 and row positive 1 or say row -3, row -1, row 1 and row 4) and how does the present row play into this?

I know you've been working on this project for a few days and looking for a solution - and I think you could get a solution but I know I need need more clarity on exactly what you are looking for and how we get to it.