Mark and Don, thanks for the help - here's some additional info --
Record 1: Company 1=Red, Company 2 = Green, Company 3 is blank, Company 4 is blank
Record 2: Company 1=Yellow, Company 2 = Red, Company 3 is Yellow, Company 4 is blank
Record 3: Company 1=Yellow, Company 2 = Green, Company 3 is Blue, Company 4 is blank
The formula field will be used as a Dynamic Filter in a Table Report. The filter choices will look like this:
Blue
Green
Red
Yellow
In the Dynamic Filters on the left side of my Table report,
If I select Blue, it will filter the report to show Record 3.
If I select Green, it will filter the report to show Record 1 and Record 3
If I select Red, it will filter the report to show Record 1 and Record 2
If I select Yellow, it will filter the report to show Record 2 and Record 3.
All the solutions I have tried have resulted in showing me only the value that is found in Company 1, so if I select Red, it will only show me Record 1, and not Record 2.
------------------------------
Ruby Kapil
------------------------------
