Trying to create a rule that substitutes different salutations,
If Salutation is Present, it should be Salutation + Last name.
If Salutation is not present it should default to First Name.
If no first name is present it should default to "Friend"
The first two functions work, but the "Friend" line does not. Just returns a blank value.
if(Field("SALU") =="")
return Field("First Name")+(",")
else
return Field("SALU" )+"" + Field("Last Name")+(",")
if (Field ("SALU") & Field ("Last Name") & Field ("First Name") =="")
return "Friend,"