Logi Composer
Documentation
Getting Started
Knowledge Base
Forums
Logi Report
Documentation
Getting Started
Knowledge Base
Forums
Logi Report API Doc
Logi Info
Documentation
Getting Started
Knowledge Base
Forums
Logi Info Sample Center
Logi Info Upgrade Advisor
Other Products
Izenda
Exago
Support
Submit a Ticket Request
View Support Tickets
License Manager
Product Download
Forums
Events
☰
Element Details: Sql+Calculated+Column+
Back
Available in: Logi Info
Source code name:
SqlCalculatedColumn
Active SQL SqlCalculatedColumn 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
ATTRIBUTES
Click attribute Name to drill down for more information.
Name
Possible Values
Description
ID
UserDefined
(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.
SqlFormula
UserDefined
(Required) A SQL formula that the database system will recognize.
PARENT ELEMENTS
Click element to drill down for more information.
DataLayer.ActiveSQL
Sql Query
CHILD ELEMENTS
Click element to drill down for more information.
Back to top