AnsweredAssumed Answered

Field Calculator Subtract Value From Previous Value

Question asked by stuart.blumberg on Mar 29, 2013
Latest reply on Apr 15, 2013 by curtvprice
Hello,

I have a field in my attribute table representing pipe lengths.  In an empty field (Distance) I would like to subtract each pipe length from the previous value, thereby calculating the distance.  Also, in the field calculator, I need to be able to sort the Pipe_Length field in ascending order before doing the calculation.  For example:

Pipe_Length.........Distance
0........................0 
1615...................1615
4494...................2879
4630...................136              

I have ArcGIS 9.3 and this MUST be done in the field calculator.  I have no access to ArcGIS 10 nor can I download an evaluation copy of it.  It must be done using 9.3 in the field calculator.  The sort ascending must also be done in the field calculator before doing the calculation.  Unfortunately I am not able to divert from 9.3 or the field calculator.  The result must be exactly how it shows in the above example.  My VB logic skills are pretty weak so that it why I am posting here!  Thank you for your help!

Outcomes