Rules

[Christian Johnson]

I need help creating a rule based on two fields.

 

In my data it is possible to have the Full Name field and Company field share the same data.

 

I need a rule that states "if Full Name field is same as Company field then return nothing, else return Company".

 

Can anyone help me?

[dreimer]

Try:

 

if (Field("Full Name") == Field("Company"))
   return "";

else return Field("Company")