Take first row value of straight table for calculation

[renjithpl]

Hi All,

See my attached qvw. i have a straight table and i need a caculation done on the last column.

In that i want to take the first row value and substract with the 5th column values to arrive second row and take second row value to get third row value..
My table should look like this:

Date1	# of Reviewers	Est Productivity	Hours/day	Docs Coded	Remaining
3/7/2011	12	9.92	8	952.38	19,047.62
3/8/2011	12	9.92	8	952.38	18,095.24
3/9/2011	12	9.92	8	952.38	17,142.86
3/10/2011	12	9.92	8	952.38	16,190.48
3/11/2011	12	9.92	8	952.38	15,238.10
3/14/2011	12	9.92	8	952.38	14,285.71
3/15/2011	12	9.92	8	952.38	13,333.33
3/16/2011	12	9.92	8	952.38	12,380.95
3/17/2011	12	9.92	8	952.38	11,428.57
3/18/2011	12	9.92	8	952.38	10,476.19
3/21/2011	12	9.92	8	952.38	9,523.81
3/22/2011	12	9.92	8	952.38	8,571.43
3/23/2011	12	9.92	8	952.38	7,619.05
3/24/2011	12	9.92	8	952.38	6,666.67
3/25/2011	12	9.92	8	952.38	5,714.29
3/28/2011	12	9.92	8	952.38	4,761.90
3/29/2011	12	9.92	8	952.38	3,809.52
3/30/2011	12	9.92	8	952.38	2,857.14
3/31/2011	12	9.92	8	952.38	1,904.76
4/1/2011	12	9.92	8	952.38	952.38
4/4/2011	12	9.92	8	952.38	0.00

Please let me know if you need further clarification, please look at the formulas i used in the column. I got 19047.62 in the first row by substracting (20000-952.38) ie. 20000 is DocsAssigned.

Thank you all in advance.

Ranjit

[sparur · Accepted solution]

Hello Ranjit

I think you should use above() function, please see in my example (Result column)

[Miguel_Angel_Baeyens]

Hello Ranjit,

The easiest way is to use labels in a new expression, so according to your graph above

[Remaining] - [Docs Coded]

Should return what you want.

Hope that helps.

[renjithpl]

Thanks for the reply Miguel, i used above function to get the answer.