O'Reilly logo

NetSuite ERP for Administrators by Anthony Bickof

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary column

The Summary column on the Results tab is used to perform calculations like an Excel pivot table. The Summary tab is used for this purpose, for instance, to count the number of records by city. The term group means "total by" in NetSuite. We group by the city and count by the name field to calculate the number of customers by city:

Totaling the number of customers by city

The choice of fields to use in the Summary Type column is crucial. A calculation based on a value in the time field within a time tracking search will error out. NetSuite provides an additional field, namely, time decimal, in order for you to create that calculation. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required