Skip to main content
Solved

Filtering out duplicated results in a specific field

  • 2 August 2024
  • 1 reply
  • 38 views

Forum|alt.badge.img

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.

Best answer by dcomerford

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.

View original
Did this topic help you find an answer to your question?

1 reply

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • Answer
  • August 5, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings