AnsweredAssumed Answered

IF Then Else statements in Field Calculator

Question asked by briarconner on Dec 2, 2014
Latest reply on Dec 3, 2014 by PGvandenBeukelesri-nl-esridist

I have been going through the forum and trying everything.  Maybe someone here can see where i have gone wrong.

 

I amd calculating the percent change and have come across only one of my properties with no value, which gives me the error of dividing by zero.  So I am using if then else statements to avoid it.  Here is the Pre-logic:

 

Dim Per1314

If [LVal2013] = 0 Then
Per1314 = 0
Else
Per1314 = [Diff1314] / [LVal2013]*100
End If

 

Where am I going wrong?   FYI: Arcgis 10.2.2

Outcomes