Sum-subtractions between rows

Question

Hi All

I am struggling with alteryx. I need from an  input  file to add some rows.

The rows to be added are  basically sums and subtractions of existing rows.  I attached you:

-The input (the file is called test input alteryx)

-The desidered output (i highlighted in yellow the columns to be added )

Is it possible to help me?

Thanks

Danilo

test input alteryx.xlsx

desired output.xlsx

Danilo9017 · Answer

@binu_acs

Not a real parameter. The input is fixed in his structure (so the order is never changing) and so on the rows to be added on the output .The row number 7 will be always given by the following formula ( row number 9-row number 8)  and should be always row number 7 (above 8 and 9)

binu_acs · Answer

@Danilo9017 My question was how are you identifying where the new rows should be added? In your example there is no pattern, you are adding new rows in 3, 7 , 10 and 15. Based on what parameter you are deciding on a new row?

Danilo9017 · Answer

@binu_acs

from file "desired output".

The row number 3 is  given by the following formula ( row number 5-row number 6-row number -row number 4)

The row number 7 is  given by the following formula ( row number 9-row number 8)

The row number 10 is  given by the following formula ( row number 11+row number 12+row number 13+row number 14)

The row number 15 is given by the following formula: (row number 3+row number)/1,22+row number 7+row number 10.

On the  desired output excel in the highlighted yellow row (column b) you will have all the logic of the formula

Really thank you for your help on this

Danilo