N/query Module
Condition.aggregate
Property Description: An aggregate function that is performed on the condition. An aggregate function performs a calculation on the condition values and returns a single value. This property is set during the execution of Query.createCondition(options) or Component.createCondition(options). This property is not applicable to parent conditions created with the execution of Query.and(conditions), Query.or(conditions), or Query.not(condition).
Type: string (read-only)
Module: N/query Module
Parent Object: query.Condition
Sibling Object Members: Condition Object Members
Since: 2018.1
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=Condition.aggregate

// Code Example 1

// Add additional code

//...

var myCustomerQuery = query.create({

    type: query.Type.CUSTOMER

});



var myAggregateCondition = myCustomerQuery.createCondition({

    fieldId: 'openingbalance',

    operator: query.Operator.GREATER,

    values: 10000,

    aggregate: query.Aggregate.MAXIMUM

});



var theAggregate = myAggregateCondition.aggregate;

//...

// Add additional code



//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1510789603.html