Form filter properties
List of form filter properties¶
Note: the list of properties displayed varies depending on the type of dimension used as the filter.
| Element | Description |
|---|---|
| FX rate | For details on this property, see Details of FX rate properties. |
| Reference FX rates | Allows you to indicate a different FX rate from the one defined in the table, for the entity for the scenario/period in use, to be used in the form navigation step. |
| Complementary | This allows the user to exclude a specific filter or node from a node of filters in a hierarchy. Thus, the system displays the entire hierarchy of the filter’s parent node or excluded node, except for the specific filter or node. Note: the additional filter is identified by the prefix |
| Size | Indicates the dimension to which the selected element belongs. Non-editable property. |
| Dimension (node/lowest level element) | Indicates whether the filter is a node or a lowest level element. |
| Dividing factor | Allows you to set the factor for the calculation of the average amount for a defined number of days or by period. |
| Periodic value calculation | Allows you to define the calculation of cumulated data as the sum of period figures (e.g. the quarterly figure for the second quarter is calculated as the sum of the monthly figures read from periods 4, 5 and 6), or as the net year-to-date values (e.g. if the period length is monthly, the quarterly figure for the second quarter is calculated as the difference between the values for period 6 and the values for period 3). |
| Comparison condition | It allows the user to define a condition for comparison, or an operator and a value with which to compare the filter value. |