Adding a Calculated Column

Create new columns based on calculations using data from existing columns in your data table.

In all cases, this new column is calculated for every row in the data set.

Steps:

1.     On the Data Source Settings pane, click Calculated Columns.

The Calculated Columns pane displays.

 

2.   Click New Column > Calculated.

 

The Numeric Calculated Column pane displays.

 

3.     Fill in the Title field.

4.     Check the Set Type Manually box. The Type drop-down list box is enabled.

5.     Select either:

·         Numeric

The most common type of calculation that allows creation of new numeric columns.

·         Text

Allows new text columns to be created based on input string manipulation.

 

NOTE	Other types of calculations include: ·         Time Series Calculation ·         Time Window Calculation ·         Time Period Calculation

 

6.     Build an expression by double-clicking in the list of available Functions and Columns.

NOTE	You can also use parameters in the expression.

 

To search for a particular column or function, enter it in the Search Columns/Search Functions box.

Or enter one or more characters/alphabets into the Search Columns box and the suggested list of columns that matched the entries will be displayed.

For example, after entering 1, the list will be displayed such as below:

7.     Set the designed display Format (for example 0.0 %).

8.     Click  to validate the formula.

9.     Click . The new calculated column is added and displayed in the Data Preview.