The Calculated Column
The Calculated Column element adds a new column to a datalayer containing a value that's the result of a formula. The formula can include data from other columns, tokens, and literals, and is evaluated for every row in the datalayer.
The following topics discuss the Calculated Column element:
About the Calculated Column
The Calculated Column is similar to other elements designed to extend the data available in a datalayer. Like the Aggregate Column element, the Calculated Column is added as a child element beneath a datalayer and adds a new column to the datalayer. This column value is derived data which is accessible using an @Data token.
The new column's value results from evaluating a formula, for each row in the datalayer. This calculated value is populated in the new column in every row of the datalayer and can be used in further calculations, Summary Rows, Link Params, etc.
Similar calculations could be performed within SQL queries and may offer better performance when done by the database server. However, the Calculated Column element allows calculations to be performed on data from other sources too, such as web services and data files, that do not themselves offer SQL-like queries.