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?