Calcualtions using fixed cells

[G_SAND]

HI All

I wonder if someone can help me with this one.

I want to do some calculations using a fixed cell with other dynamic cells:

	Field1	Field2	Field3	(Explanation)
Row1	A	1	20
Row2	B	2	40	(Row2,Field2 x Row1,Field3)
Row3	C	3	60	(Row3,Field2 x Row1,Field3)
Row4	H	7	30
Row5	I	8	240	(Row5,Field2 x Row4,Field3)
Row6	J	9	270	(Row6,Field2 x Row4,Field3)
Row7	K	10	300	(Row5,Field2 x Row4,Field3)
Row8	X	15	40
Row9	Y	16	640	(Row9,Field2 x Row8,Field3)
Row10	Z	17	680	(Row10,Field2 x Row8,Field3)

The numbers in bold in Field3 are already there and those are the fixed calculation points, so its just the calculation to bring the red numbers in.

I'm sure someone can give me a solution to this.

Thanks in advance.

[nick_ceneviva]

The attached solution seems to do the trick.  I'm sure there are countless other ways to do this though.

The multi-row tool is used to give a grouping ID to the cells below the fixed cells.  Then the rows with the fixed cells are separated from the other rows using the filter tool.  The grouping ID and the fixed cell are appended to the rows that need the calculation for Field3.  The calculation is done and then the fixed cell row is added to the results using the union tool.  The results are then cleaned up using the sort and select tool so that the output matches what was used in your example.

Hopefully this helps and let me know if you have questions! 

[patrick_digan · Accepted solution]

@G_SAND I just put more logic into the multi-row and formula tools and used a temp field.