AnsweredAssumed Answered

Help with an equation?...

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


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 = "" ; Freight Carrier = "FedEx" ; freight carrier websites = "")

Can anyone see what I am doing wrong?