Columns 9 and 10 are editable in the following cases:
Use case |
9 |
10 |
Main indicator without sub-indicator (“of which”) and without formula |
Editable, optional |
Editable, mandatory |
Main indicator without sub-indicator (“of which”) and with formula |
Editable, optional |
Not editable, calculated |
Main indicator with sub-indicator (“of which”) and without formula |
Editable, optional |
Editable, mandatory |
Main indicator with sub-indicator (“of which”), with formula and mandatory breakdown |
Editable, optional |
Not editable, calculated |
Main indicator with sub-indicator (“of which”), with formula and optional breakdown having an achieved value different from 0 in one of the sub-indicators |
Editable, optional |
Not editable, calculated |
Main indicator with sub-indicator (“of which”), with formula and optional breakdown having no achieved value (null) in all sub-indicators |
Editable, optional |
Editable, mandatory |
Sub-indicator (“of which”) with formula |
Editable, optional |
Not editable, calculated |
Sub-indicator (“of which”) without formula and with mandatory breakdown |
Editable, optional |
Editable, mandatory |
Sub-indicator (“of which”) without formula, with optional breakdown, main indicator achieved value not null and all sub-indicator achieved values null |
Editable, optional |
Not editable |
Sub-indicator (“of which”) without formula, with optional breakdown and sub-indicator achieved value not null |
Editable, optional |
Editable, mandatory |
Formulas for Common Result Indicators to calculate the achieved values in column 10: