How to generate a new row based on the subtraction of the above two rows?

[fullmoon558]

Hi folks,

I need some help for the following row generation/calculation. I need to generate a new row (Row 3) and this row is the result from (Row 1) minus (Row 2). I have been trying multi row formula but I could not figure it out. Can anyone please help me? Thank you.

	Apple	Pear	Melon
Row 1	3	5	4
Row 2	2	3	1
Row 3	1	2	3

[markcurry]

Hi @fullmoon558 

See the attached workflow that has a few methods you can use to do this.  The easiest probable the 2nd one.  As long as it's always 2 rows you're just dealing with.  You could use the Multi-Row tool, but you'll need a tool per field.  

Hope that helps,

[binuacs]

@fullmoon558 One way of doing this

[fullmoon558]

Thanks folks. Any easier way to automate this? Or I only have the cross tab and multi-formula row options. Is there a tool that I can generate a new row based on the calculation from previous two rows?

[binuacs]

@fullmoon558 Another method

[fullmoon558]

Thanks binuacs!