I have a field that is a string {Property.LANDINGZONE}. The formula below is not returning the correct results. I am assuming I need to convert the string into a number, but not sure how to do this.
if {Property.LANDINGZONE} in "0" to "7500" then 1
else
if {Property.LANDINGZONE} in "7501" to "14999" then 2
else if {Property.LANDINGZONE} > "15000" then 3
Any help would be appreciated.
if {Property.LANDINGZONE} in "0" to "7500" then 1
else
if {Property.LANDINGZONE} in "7501" to "14999" then 2
else if {Property.LANDINGZONE} > "15000" then 3
Any help would be appreciated.