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.
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.
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?