|
ErrorLimit | | 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 | | 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 | | (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 | | (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. |