Field Calculater

AbhishekMisra

Dear tech Support Team,
I am working on table i want some correction in script for calculating field
I have Data in Grid_code field in the form of 1 to 6
In grid_code field there is value 1 to 6 i want 1 is convert as Very low, 2 Is Low, 3 is Moderate, 4 is High and 5 is Very high in Class field i am using following script

Dim Output as String
If [Class] = 1  Then
Output = "Very Low"
Elseif [Class] = 2 Then
Output = "Low"
Elseif [Class] = 3  Then
Output = "Moderate"
Elseif [Class] = 4  Then
Output = "High"
Elseif [Class] = 5  Then
Output = "Very High"
Elseif [Class] = 6  Then
Output = "Extreme"
Else
Output = "xyz"
end if
Please help me to correct this script or please tell me where i get solution


Thanks & Regards
Abhishek Misra

RichardFairhurst

Ok. I missed that your code had at least 3 syntax errors. I overlooked them, because the syntax is so basic. “AND” is a Logical Operators used to link expressions that evaluate to True or False (See this link for logical operator help<http://msdn.microsoft.com/en-us/library/4ah2h0k3(v=vs.84).aspx>). You have to use “>=” not “= >” (See this link for comparison operators<http://msdn.microsoft.com/en-us/library/9hck4s70(v=vs.84).aspx>). You have to use “ElseIf” not “Else If” (See this link for If Else Then syntax<http://msdn.microsoft.com/en-us/library/5h27x7e9(v=vs.84).aspx>). You should study this MSDN website and learn more about VB Script syntax.

If <= 1000 Then

Output = "I"

Elseif > 1000 AND <= 3000 Then

Output = "II"

Elseif > 3000 AND <= 5000 Then

Output = "III"

Elseif > 5000 AND <= 10000 Then

Output = "IV"

Elseif > 10000 Then

Output = "V"

Else

Output = "xyz"

End If

image001.jpg