Modules

filter

 

Objects/Functions

module (N/query)

SuiteScript 2.0

Column.formula

// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=Column.formula for more information.

N/query Module
Column.formula
Property Description: A formula used to create the query result column. This property is set during the execution of Query.createColumn(options) or Component.createColumn(options). This property and the Column.fieldId property cannot be set at the same time. For more information on formulas, see Formulas in Search and SQL Expressions.
Type: string (read-only)
Module: N/query Module
Parent Object: query.Column
Sibling Object Members: Column Object Members
Since: 2018.1
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=Column.formula

Example:

// Code Example 1
// Add additional code
//...
var myTransactionQuery = query.create({
type: query.Type.TRANSACTION
});

var myFormulaColumn = myTransactionQuery.createColumn({
type: query.ReturnType.CURRENCY,
formula: '{amount} * 125'
});

var theFormula = myFormulaColumn.formula;
//...
// Add additional code

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