I feel like I am pretty close to a solution, but I could use some help closing the gap.
I have an app that allows our staff to collect data for a contractor to complete a quote. Once the data collection is complete, the staff member which contractors they want to deliver the data to using an ENUMLIST. I am trying to determine how many times we have delivered quote opportunities to a contractor.
I am using the following expression to try and get the count, but since multiple contractors can be selected, I need to use an asterisk (*) wild card before or after the contractor name since it could be anywhere in the string. How do I apply wildcards when using an expression like this? Also, will this accomplish what I am looking for?
=COUNT(FILTER("Product", [Assigned Leads] = QCN[CompanyName]))
- Product is the table where the data is stored
- Assigned Leads is the column storing the selected contractors (ENUMList)
- QCN[CompanyName] is the table/column with each of the contractors we partner with
I hope I’ve given enough information. Searching this forum has gotten me this far. I appreciate any help to get me the rest of the way!