Element Details: DsCalculated+Column

Available in: Logi Info Source code name: DsCalculatedColumnIntroduced in: 12.5

DsCalculatedColumn adds a calculation/formula operation to a Dataview for DataLayer.DataServices.

A Calculated Column adds a new column in the DataLayer from other values in the same row, or from other token values. The column can be used like any other column.

Set the ID to the name of the new column.

Example: Suppose you have an Order table with Price and Qty. You could create a Total column with a Formula attribute like:

@Data.Price~ * @Data.Qty~

Element Group:Add and Replace Columns


Click attribute Name to drill down for more information.

NamePossible ValuesDescription
(Required) DsExpression is a DataServices formula which returns a value. To represent the value of a data column, wrap the column name in square brackets. Example expression: [Weight] * [PricePerPound] + .05
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
An expression that evaluates to a value of True or False. If the expression is blank, or evaluates to true the element is processed. If the expression evaluates to false, the element is skipped. Expressions should be in VBScript or JavaScript syntax. For .NET versions, the scripting language can be set in the _settings.lgx General element. For Java versions, the scripting language is always JavaScript. Typically, you would compare values using an operator, such as "@Session.value~ < 0". Use quotes when working with strings: "@Session.myValue~" == "SomeValue"


Click element to drill down for more information.

DataLayer.Data Services


Click element to drill down for more information.

 Back to top