Formula Error

[donnarenia]

if {?Salesperson} = "Salesperson 1" then {CLNTCUS.~Custom20}else
if {?Salesperson} = "Salesperson 2" then {CLNTCUS.~Custom22}

What does the error "The formula result must be a string" mean in reference to the above formula that I am trying to enter in the display spring for a field

 

[lbass]

IF these values are numbers, you have to convert them to strings, as in:

if {?Salesperson} = "Salesperson 1" then
totext({CLNTCUS.~Custom20},0,"") else
if {?Salesperson} = "Salesperson 2" then
totext({CLNTCUS.~Custom22},0,"")

-LB

 

[donnarenia]

Thanks that was very helpful...You are the BEST