5.4 Calculated Fields

You can perform calculations on existing data fields within a Viewsheet to create new “calculated” data fields. You can then use these calculated fields in the bindings of Charts, Crosstabs, and other elements.

This is especially useful for Viewsheets that are not based on Worksheet data sources (such as Viewsheets based on queries or data models) and do not have access to the Worksheet's computational tools. In such cases, the Viewsheet's calculated field feature provides an equivalent to the Worksheet's expression column feature. The Viewsheet's calculated field feature also aids in calculations that require access to post-aggregate quantities, such as rates and ratios, which can be challenging to configure within a Worksheet.

Note: For Worksheet-based Viewsheets, you can make detail-level calculations within the Worksheet itself. (See Creating an Expression/Formula Column in Data Mashup.) To perform aggregate-level calculations, use the Viewsheet methods described below.

There are two different kinds of calculated field:

Calculated field based on detail data: A calculated field based on detail data can be used as either a dimension or measure (see Converting between Measure and Dimension) in the same manner as any other data field. See Creating a Calculated Field from Detail Data for more information.

Calculated field based on aggregate data: A calculated field based on aggregate data can be used only as a measure. This type of calculated field cannot be bound to Selection Components (Range Slider, etc.). See Creating a Calculated Field from Aggregate Data for more information.

The following sections explain how to create these two types of fields.

<< 5.3.3 Passing Multiple Parameters in a Hyperlink © 1996-2013 InetSoft Technology Corporation (v11.5) 5.4.1 Creating a Calculated Field from Detail Data >>