Is there a way to set a condition in Acumatica’s GI editor that will filter down to only unique results for a given field? in this case I have a report I created that pulls contacts with specific fields filled out and one of the fields in the results is the “Full Name” or Account Name; I would like to only have one result per Account name.
I am doing this to try to parse out some KPI Data for management, they want to get the number of accounts that each sales rep has at least 1 Contractable Ingredient with out of a list of their total accounts in their possession. so even if there are 5 contacts with 5 ingredients we only want to see one of them for counting purposes.
Filtering out duplicated results in a specific field
Page 1 / 1
You could try using the Group by ContactID that should give you one record but it may not show you the ingredient as it can only show one record per Contact.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.