Sum-subtractions between rows

[Danilo9017]

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 

[binuacs]

@Danilo9017 what is the logic to add a new row? I mean based on what condition you are adding a new row?

[DanM]

Check out this lesson on how to format data in Alteryx. I would also suggest checking out the samples for Cross Tab and Transpose tools.

https://community.alteryx.com/t5/Interactive-Lessons/Formatting-Data/ta-p/76255

[Danilo9017]

@binuacs 

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

[binuacs]

@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]

@binuacs

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)