Skip to main content
Participant
August 5, 2020
Question

Syntax Error? Every thing works except one option.

  • August 5, 2020
  • 0 replies
  • 295 views

I have created a web form ever thing works fine except one of the look ups, and i cant understand why all the rest work fine.

The form uses a drop down then a calculated filed, again it works fine except for the "26 Feet To 30 Feet=200" part. The calculated field function is:

 

if([Vehical_type]="Pontoon Boat", lookup(vehicle_size_boat_rv, "18 Feet or Under=160,19 Feet To 25 feet=180,26 Feet To 30 Feet=200, 31 Feet To 35 Feet=220, 36 Feet To 40 Feet=270, Over 40 Feet=300","TBD") + 20,if([Vehical_type]="RV", lookup(vehicle_size_boat_rv, "18 Feet or Under=160,19 Feet To 25 feet=180, 26 Feet To 30 Feet =200, 31 Feet To 35 Feet=220, 36 Feet To 40 Feet=270, Over 40 Feet=300","TBD"), if([Vehical_type]="Boat", lookup(vehicle_size_boat_rv, "18 Feet or Under=160,19 Feet To 25 feet=180, 26 Feet To 30 Feet =200, 31 Feet To 35 Feet=220, 36 Feet To 40 Feet=270, Over 40 Feet=300","TBD"), if([Vehical_type]="5th Wheel", lookup(vehicle_size_boat_rv, "18 Feet or Under=160,19 Feet To 25 feet=180, 26 Feet To 30 Feet =200, 31 Feet To 35 Feet=220, 36 Feet To 40 Feet=270, Over 40 Feet=300","TBD"),"TBD"))))

 

 

The list form the drop down is: 

18 Feet or Under
19 Feet To 25 feet
26 Feet To 30 Feet
31 Feet To 35 Feet
36 Feet To 40 Feet
Over 40 Feet

This topic has been closed for replies.