ANS-0063 · SAVED SEARCHES & FORMULAS
How to Count Distinct Values in a NetSuite Saved Search Summary Formula?
NetSuite users can ensure accurate aggregate reporting by correctly applying the 'distinct' keyword in summary formula fields.
Short answer
To count only unique values in a NetSuite Saved Search summary formula field, prepend the 'distinct' keyword directly before the field name within the formula. This ensures that the count aggregates unique records rather than every individual line, providing accurate summary results.
Scenario
When creating a NetSuite Saved Search with a summary count in a formula field, users may observe that the count reflects individual lines rather than unique values. For instance, a count intended to show unique 'SO Items' might incorrectly display a total that includes duplicate line items, indicating that every line is being counted instead of distinct entries.
Solution
To count only the unique records in a summary formula field, add the keyword distinct directly before the field to be counted.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support