AnsweredAssumed Answered

Help with an equation?...

Question asked by paintboothguy on Jan 21, 2011
Latest reply on Jan 21, 2011 by philmodjunk

Title

Help with an equation?...

Post

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?

Thanks!

Outcomes