This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

```            search.createFilter({
                name: 'formulanumeric',
                formula: 'count(lineuniquekey)',
                operator: search.Operator.LESSTHAN,
                values: 10000,
            })```
Any ideas why this formula is returning an error?

Searching on a Sales Order record.

summary filters require at least one grouping summary column

a difference between the ui and scripts is that the ui will ignore the summary filter while a script throws an error

```        columns: [
            search.createColumn({
                name: 'internalid',
                label: 'Internal ID',
                summary: search.Summary.GROUP
            }),
        ],```
Grouping like so but it doesn't like my formula for some reason.

your formula may be off, mostly because it doesnt look like a formula

then load it in script to see what the filter looks like

Yup, that's what I did.

Originally it looked like:
```   ["count(lineuniquekey)","lessthan","10000"]```
But I was just trying to convert it into the typed options

importantly, that filter expression is not a formula