I am trying to find the total number of occurrences of a text value in a list for a document collection. I have Form A with a field for employee name. I am doing a DBLookup against a view of Document B which has a multiple value field containing empoyee names. I need to find the total number of documents in the Document B view that contain the employee name in each Document A. I tried @Count(@DBLookup…) but this is returning the total number of all list items in the list for each list containing the key value from Document A.
Thanks