Conditional editability expression window
Excel > CCH® Tagetik > 
Design > open Matrix Wizard > select a row/column filter > (Properties grid) Conditional editability expression > 
Purpose of window¶
This window allows you to define the condition that needs to be met to make a matrix row/column filter editable.
Window sections
| Element | Description |
|---|---|
| Minimum editability level | Defines the editability type to be assigned to the cell when the condition is not met: - Protected: the cell is not editable for direct entry, but only via formulas. - Not editable(default): the cell is not editable. |
| Row/column | Allows you to define the logical expression on rows/columns based on the condition to be met. |
Details of the expression for the condition to be met
| Element | Description |
|---|---|
| Row/column | Row/column on which to verify the condition. The row/column to which the check relates must be static. |
| Operator | - isTrue and isFalse: operator referring to a cell containing a Boolian or numeric value (0=false, <>0= true). - =, <>, >, >=, <, <= - Between (included between): defines a range of numerical values, a string or data within which the insertions must fall. The first and last values are included in the range. - IsEmpty: the condition is met if the cell is empty. - IsNotEmpty: the condition is met if the cell is not empty. - IsNumeric: the condition is met if the cell contains a numerical value. - IsString: the condition is met if the cell contains a text-based value. - IsInteger: the condition is met if the cell contains a whole number. Any decimal figures introduced by copying and pasting will not be saved. |
| Type | Defines the type of data on which to verify the condition. Is only required for some operators. The available options are: - Number - Body - Date |
| Reference value | Defines the reference value to run the check. |
| Adds an expression to the condition. | |
| Removes an expression from the condition. | |
| Concatenation of several conditions | Only with several conditions based on several expressions. Defines the relationship between the individual conditions. - AND - OR |