3 Replies Latest reply: Apr 13, 2012 5:10 AM by swuehl RSS

expression answer

Carlos Adolfo Renteria

hello,

 

i have a table with this data:

 

Year    |  Total

2001    |    2

2002    |    4

2003    |    6

 

i put this into a chart table and i need to make an expression  on the line 2002 doing the follow thing:

 

Year    |  Total   |   Expresion

2002    |    4     |  total2002/Total2001 - 1 = 1

2003    |    6     | total2003/Total2002 - 1 = 0,5

 

and so forth with a table of many more values

.

how would be this expression?

 

tnk's,