Creating Calculated KPIs

STEP 1: To create a calculated KPI follow the steps required to create a single KPI and select “Calculated” for KPI type.

The only available Aggregation option for a Calculated KPI is ‘Normal’ and the only available Time Horizon option is ‘Period’. Calculated KPIs cannot have any other selections for these fields.

Once a calculated KPI is created and saved, an additional ‘Sub KPI’ tab will appear where you can either create new sub KPIs or select existing KPIs as sub KPIs.

STEP 2: Click the 'Sub KPI' tab.

On the right hand side you can see a list of potential sub KPI’s. Not all existing KPIs are eligible - scroll down to the end of this topic for a complete list of business rules;

STEP 3: To add a sub KPI, select the required KPI and drag from the KPI list on the right onto the list of sub KPIs in the centre of the screen. The dotted blue line surrounding this section indicates the KPI is in the correct spot to be dropped and linked. When you have added all the sub KPIs you need, click SAVE and move to STEP 4.

If the KPI you require is not available in the list and must be added to the database, click the 'New' button to create your new KPI. Enter the information required and click SAVE to commit the entry. You will notice that this has automatically been added as a sub KPI to your original Calculated KPI. Similarly, create as many sub KPIs as required.

STEP 4: Enter a formula to calculate the actuals.

The formula can contain the alphabetical codes assigned automatically to the sub KPIs as well as the universal symbols for add, subtract, multiply, divide and open/close brackets.

STEP 5: Click the 'Save' icon.

Sub KPIs should be with the same period or less to that of the Calculated KPI to link with. (e.g. if calculated KPI had period of monthly, then sub KPIs which could link are only monthly, weekly or daily – not yearly)
If there is no sub KPI available in the list, users will be enabled to click on “New” to create a sub KPI within the Calculated KPI
Sub KPI linkage has no effect over calculated KPIs, meaning calculated KPIs can be linked to any level of the hierarchy.
Sub KPIs have a formula code a, b, c etc. A formula can be entered which will derive the “calculation” for the calculated KPI.
Sub KPIs will be assigned with a code automatically, which the user can use in the formula (ex- (a*b)/c). This can go up to any number (ex ab,zz).
When a sub KPI is removed from the list, if it is already included in to formula, a warning message will display “If the sub KPI is removed from the list, the specified formula will be invalid and formula will be cleared. Are you sure you want to remove?” User can click “ok” or “cancel”

• If user selects “Ok”, the sub KPI will be removed from list and formula text box will be cleared.

• If a sub KPI is removed and it is not selected for formula yet, an information message will be displayed saying “The sub KPI code and formula will be rearranged accordingly”. If user selects “Ok”, automatically the KPI codes in list and formula will be re arranged.

Last revised: September 04, 2018