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,