Christian Johnson Posted November 30, 2018 Posted November 30, 2018 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? Quote
dreimer Posted December 3, 2018 Posted December 3, 2018 Try: if (Field("Full Name") == Field("Company")) return ""; else return Field("Company") Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.