Need Help to Create Formula Field

[42894]

Hi there,

I am using CRXI. I want to create a formula field. Below are details.
For Example:
I have 2 fields and values of that fields
A Owners B Owners
--------- ----------
A1 A1
B1 B1
C1
I want to add 1 formula field in my report for if more than 2 values are equal in A Owners and B Owners then it should show "YES" as separate field. Here it should display YES. Because A1 and B1 are in both the fields.

I would appreciate your help.

Thanks in advance
Aatman

 

[spcc07]

You should be able to create a formula similar to

@CheckOwners
If A.Owners.field = B.Owners.field
then "Yes"
else
"NO";

Put this formula in the same row as the fields generating A1,B1

 

[42894]

Thanks for your reply.
But in every record i have A Owners and B Owners fields but both have multiple values in single record.

A1,B1,C1 all values are under single record. Other record might be have B1,A1,H1 for A owners. Same for B Owners field.

So i don't understand how to do if more than 2 A Owners are equal to B Owners in a single record then show Multiple(Field name) "YES"