Calculated Column

A calculated column is a column generated as a result of a mathematical expression applied to one or more columns in a DataModel. You can provide more than one mathematical expression on multiple columns of a DataModel. This will generate a new DataModel which will contain the existing and the calculated columns.

Let's take a basic example of tabular data in a DataModel.

In the above data, we have columns for Month, Revenue and Profit. The mathematical formula to calculate the Profit % is, (Profit *100) / Revenue. To create a new column for Profit %, with the existing ones, refer to the code below:

CalculatedColumns calculatedColumns = new CalculatedColumns {
   {"(Profit * 100) / Revenue","Profit %" }
};
DataModel resultModel = model.AddNewCalculatedColumns(calculatedColumns);COPY

In the above code:

• calculatedColumns is an object which holds information of the data to be calculated.
• model is an object of the source DataModel.
• resultModel is the object which holds the resultant data.

The new data of the newly created DataModel after applying the above formula to the table is shown below:

The code to dispose the calculatedColumns object is given below:

calculatedColumn.Dispose();COPY

In the above code, calculatedColumn is the object that holds the names of the columns created with the data derived via the mathematical expressions.

If the column name of a table includes space, for example, Order Date provide it in the mathematical expression as [Order Date].