Search

Measurement in NetSuite Workbook Pivot Table

About Calculated Measurement Feature


A calculated measure is a measure provided in a NetSuite Workbook that can create pivot tables and charts directly in your NetSuite account using arithmetic operations with base measures. You can define a calculated measure using fields from the underlying dataset of the workbook visualization you are in. If you want to create a calculated measure using different fields, simply edit right on the dataset or contact the dataset owner if you are not the original author (permissions required).


When you create a calculated measure table, do not forget to define the field and basic operators of your calculation. All calculated measures must include a name and a valid data definition. As you create your calculated measure, a message at the bottom of the editor indicates if the definition is valid. As if it is not, an error icon will appear next to the line that contains validation errors. You can hover over the warning icon to see how to correct the definition.


Moreover, you can edit and delete it from the Layout panel of the visualization.


Using The Recent Features of NetSuite Workbook Calculated Measurements


Unlike formula fields which are built at the dataset level to evaluate results on each single row basis, calculated measures are now built on the workbook level using aggregated results. For example, if you create a formula field that calculates sales amounts, each row in the dataset will show a single value based on the formula definition. If you then use that formula field as a measure in a pivot table or chart, the results are simply an aggregate of the formula field results. By contrast, calculated measures use the aggregated results of base measures combined with arithmetic operations to display results such as year over year variances and profit percentages. These types of results are not achievable using formula fields alone.


You can create as many calculated measures as you need     using the fields available in the connected dataset, including custom     formula fields. However, you can only use your calculated measures in the     pivot tables or charts where you created them. 
  




Create your calculations at ease with available fields in the Dataset Panel and basic operators. To create your calculations, you can do the following:

  • Type a field name in the editor or drag a field from the Dataset panel to the editor.

  • Type a basic operator such as plus (+), minus (-), multiplied by (*), divided by (/), and parenthesis ().

  • (Optional) To change the aggregate function of the selected field, click the Field Menu icon next to the field name.

  • (Optional) To display all options, press Ctrl + Space and select the fields and operators that you want to add.


27 views0 comments