1 Reply Latest reply on Jan 21, 2011 10:33 AM by philmodjunk

    Help with an equation?...



      Help with an equation?...


      Good morning Forum.

      I have set up a calculation field that I would like to have report a string of text based on the text in another field that has a drop-down list.

      For instance, if the drop down list named <Freight Carrier> has had "UPS" selected, I'd like the calculation field named <freight carrier websites> to display the tracking website URL.

      I have used the equation below and I get a "0" in the calculation field when I select "UPS" or "FedEx" in the drop-down field:

      Case (Freight Carrier = "UPS" ; freight carrier websites = "http://www.ups.com/tracking/tracking.html" ; Freight Carrier = "FedEx" ; freight carrier websites = "http://www.fedex.com/Tracking?cntry_code=us&link=4")

      Can anyone see what I am doing wrong?