Element Details: Extra+Crosstab+Calculated+Column
 Back


Available in: Logi Info Source code name: ExtraCrosstabCalculatedColumn

By default, the CrosstabFilter produces a single value for each column and row combination. ExtraCrosstabCalculatedColumn allows a formula to be used to create additional values.

These values can be displayed in a CrosstabTableValueColumns element. In the Label element use the special token:

@Data.rdCrosstabValue-myID~

(Replace myID with the ID of this element.)

The formula may reference special crosstab tokens. For example, if the CrosstabValueColumn is "Cost" and an ExtraCrosstabValueColumn is "Price", we can calculate "Profit" with:

@Data.rdCrosstabValue-Price~ - @Data.rdCrosstabValue~

In this case "Price" is the ID value of an ExtraCrosstabValueColumn. @Data.rdCrosstabValue~ represents the "Cost" because it's the main value created with the CrosstabFilter.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ErrorLimit
UserDefined
Error Limit sets the maximum number of times a Calculated Column can have an error. After the limit is reached, the Calculated Column returns an empty value. Error handling for Calculated Columns can be expensive in terms of performance when there are hundreds or thousands of errors. Error Limit can prevent too many errors.
ErrorResult
UserDefined
ErrorResult sets the value that is used whenever the Condition or script formula fails because of an error. For ConditionFilters, the default is "False". For CalculatedColumn and ExtraCrosstabCalculatedColum elements, the default is blank. Otherwise, the default is "???". Label's Caption attributes can have a script formula by making the first character the equals sign: "=".
Formula
UserDefined
(Required) A VBScript or JavaScript expression that returns a string or numeric value. Select the scripting engine from the Settings General element's ScriptingLanguage attribute.
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.



PARENT ELEMENTS

Click element to drill down for more information.

Crosstab Filter


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top