AnsweredAssumed Answered

Field calculate n+2 into a new field

Question asked by maaronweber on Sep 23, 2014
Latest reply on Sep 23, 2014 by maaronweber

I have a field of values 1,2,3,4,....400. I would like to calculate those values into a new field where the value of the SECOND record is 1+2, the third is 2+2,  etc, moving in what is basically a diagonal pattern down the list... I know how to do this in excel, but I don't want to take my .dbf out and mess with all that. I know there is a way in field calculator, it's just escaping me right now.

 

Here is an example of what I'm looking for,

 

LFLT
86
8887
8988
9089
9190

 

The field LT is already populated, and I want to calculate values into the LF field that are +2 of the value above it. Hope that makes sense?

 

Thanks!

Matt

Outcomes