Simple conversion and formula calculations

You might want to, for example, perform unit conversions of the values in a data column, or use formulas to calculate new values, and then add the results as values in a new data column.

The following are simple examples of retrieving more information than is available in the data table from start. New data columns, based on the existing data columns, are calculated and added to the original data table.

Converting currency

Below, Euro amounts in a data column are converted to USD using the exchange rate 1.16. The results are added into a new column named USD.



Note: The calculated column is immediately available in the Data in analysis flyout, but it might not be visible automatically in the table visualization. To show the column in a table visualization, do the following:
  1. Right-click the table, and select Properties in the opened menu.
  2. In the popover, select Columns.
  3. Click Select columns.
  4. In the Select columns dialog, select the calculated column in the Available columns pane, and click Add.
  5. Click Close.

Calculating BMI

In this example, the original data table shown to the left lists 'Height (m)' and 'Weight (kg)' for a number of individuals. Based on these data columns, Body Mass Index, BMI, can be calculated. The formula

[Weight (kg)]/([Height (m)]*[Height (m)])

is entered in the Add calculated column dialog, and its results are added as a new data column in the data table to the right.