A Data select calc column is is a calculated column that is added to the columns that come from the dictionary that the data selection references.
The values for each cell in a calculated column are calculated by the system when the data selector dialog is displayed using the column's value expression.
Ordering
Data selector calculation columns and data selector filters can be arranged in relation to each other. If a calculated column is not needed during filtering, it is recommended to place calculation columns after all filters to reduce the number of cell values that are calculated and improve performance.
Settings
Data selector calculation columns have the following settings:
Setting name |
Description |
|---|---|
Name |
Name of calculated column used for referral in expressions. Note! The names are identifiers which means that they must start with a letter or underscore and may only contain letters (a..z, A..Z), numbers (0..9) and underscore (_). The Swedish characters åäöÅÄÖ are also allowed. |
Notes |
Internal notes. |
Value type |
Data type with Bool, Double, Int or String as possible values. The default is Int. |
Value expression |
Formula to calculate cell values. See the ActiveKey() method for how to access dictionary values from the active row in an expression. |
