Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need Help to Create Formula Field

Status
Not open for further replies.

42894

Technical User
Mar 16, 2008
11
US
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
 
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
 
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"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top