Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Grouping changes search total
I have the following saved search on a custom record type called Work Order:
CRITERIA:
Inactive is False And
Work Order Type is Sales Order And
Reporting Status is not Terminated And
Date Created is on or before 5/31/2012 And
( Date Completed is after 5/31/2012 Or
Date Completed is empty )
RESULTS:
Assigned To (employee field)
Name (Unique ID, standard field)
Total Found: 742
I'm having problems because when I change the Results to have Assigned To be a Group summary type, and Name to be a Count summary type, then I get
Total Found: 741.
This problem only seems to occur when using Group and Count on my fields. I want the correct total, but I also want Grouping. what's wrong here?
Tagged:
0