Christian Johnson Posted November 30, 2018 Share 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 Link to comment Share on other sites More sharing options...
dreimer Posted December 3, 2018 Share Posted December 3, 2018 Try: if (Field("Full Name") == Field("Company")) return ""; else return Field("Company") Quote Link to comment Share on other sites More sharing options...
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.