Thank you for your post.
PatternCount is the correct function to use. PatternCount returns the number of occurrences of a text string inside a field. Therefore, If CompName is "ABC Las Vegas", PatternCount (Proposal_CONTACT::CompName ; "ABC" ) will return 1. Your calculation could then be modified to:
PatternCount (proposal_CONTACT::CompName ; "ABC" ) > 0 ; 0 ;
ValueCount ( FilterValues (proposal_CONTACT::CompName; "DEF Event Technology" )); 0;
ValueCount ( FilterValues (proposal_CONTACT::CompName; "GHI Media Services" )); 0;
See FileMaker Pro Help ( Reference -> Functions reference -> Text functions -> PatternCount ) for more complete information about the PatternCount function.
But I'm a bit concerned that you are using filtervalues at all here. What data do you have in compname? if this is a single company name as I would expect to see here, FilterValues really isn't the correct function to use at all here.
Thank you. I was initially using PatternCount and will probably convert the other two back to it. I was just having a hard time figuring out why it had to be an exact match but now it makes PERFECT SENSE. Thank you so very much TSGal.