arcgis-10.0arcgis-desktoparcmapfield-calculatorvbscript
I can't figure out why the syntax is wrong in Field Calculator ArcMap 10. The complete codeblock is
Dim CapitalDia As Number
Dim TwagDia As Number
Dim X As Number
CapitalDia = [New_Pipe_S]
TwagDia = [DIAMETER_1]
If CapitalDia= 0 Then
X = TwagDia
Else
X = CapitalDia
End If
And then, the bottom window is
Final_Dia =
X
It might be because you're using a field name where a parameter name should go.
Instead, try something like:
def avg(paramName):
return 10
You need to pass the returned value in a variable, not reference the column itself.
Expression:
result
Codeblock:
if [ColumnB] > 0 then
result = [ColumnA] / [ColumnB]
else
result = 0
end if
Here's how the two parts fit together in the field calculator - my data doesn't have the same field names, but you get the idea.
Best Answer
The "as Number" is what's causing the error. Just use "dim X"