Formula Tab

Formula Gauge

Pentana Risk Formula

Calculates Forecast


Related Topics:

Standard Menu Bar



key1Essential Permissions:

PI_Admin (+ complex)


PI_Links (+ complex)

PI_Owners Edit (+ complex)

PI_Note create (+ complex)

PI_Targets Edit (+ complex)

PI_Thresholds (+complex)

PI_Update data (+ complex)


key1Related Permissions:

Site Admin


Formula Gauge

Tick this checkbox to enable this PI to be driven by a formula.  Once ticked the remaining fields, as described here, are made available.

You will be warned that changing your PI to a formula will automatically change your data collection settings to show the source as formula, click create if you want to continue with this.


Pentana Risk Formula

If desired, Pentana Risk can be set to calculate the PI result from source data held elsewhere in the system. The actual formula used to specify how the PI is calculated is stored here. Formulas are specified in a similar way to Excel, except that instead of using cell references here you use the PI code.

Brackets can also be used to separate each part of the formula.


Note: If you have PI codes that contain either mathematical symbols (-, +, / and *) or spaces as these will prevent the formula from calculating correctly unless you surround them in double quotes ("), i.e. code "L-001" in a formula to stop this being interpreted as PI "L" minus PI "001".


Note: Pentana Risk will use this formula only if you choose formula from the source drop-down list in the Data Collection Settings.


Example 1:

If you first set up two PIs, one with the code POP and name 'Population' and another with code CP and name 'cost of planning service', then the PI cost of planning service per head of population can be calculated by entering the formula: CP/POP.

Example 2:

% of invoices paid within 30 days can be calculated with the formula IP1/IP2*100 where IP1 is number of invoices paid within 30 days and IP2 is the total number of invoices.

Example 3:

Average days sickness at corporate level can be calculated using SK1+SK2+SK3+SK4/4 where SK1, SK2, SK3 and SK4 are days of sickness in individual departments.

Example 4:

Average time for calls for number of divisions could be calculated by using
(CallTime_Div01 + CallTime_Div02 + CallTime_Div03) / (NoCalls_Div01 + NoCalls_Div02 + NoCalls_Div03)
where CallTime is the total length for all calls for that division and NoCalls is the number taken for each division.


Note: If you enter N/A in any of the feeder PIs, if the formula uses only plus and minus then the PI will be ignored, otherwise the result will show N/A.


When setting up PIs to be used within a formula, the feeder PIs' data shouldn't be activated until the formula has been entered within the formula PI.


Formulas only work going forward; i.e. on the values activated after the formula has been setup.  You can recalculate all the historic values by pressing the Recalculate Formula Data button, which can be found in the toolbar.  


You will be asked if you are sure you wish to recalculate, as all existing data will be replaced by this Action.  To continue press Recalculate.


Formulas with Numerator and Denominator PIs

Formulas will work with Numerator and Denominator PIs, and you will need to have feeder PIs that have been setup as numerator and denominator PIs also.

For example: you may have 3 departments who pay invoices, therefore you'd have three feeder PIs with a numerator of 'No of Invoices Paid' and a denominator of 'No of Invoices' and these would individually create a percentage for each department.  Then on the formula PI you would sum department1 + department2 + department3 and total number of invoices paid and number of invoices would be automatically added to the numerator and denominator to create an overall percentage.

Back to Top

Calculates Forecast

Tick this box if your PI contains a formula and you would like the same calculation to be applied to the forecast values on the feeder PIs to create the forecast value on this PI from the forecast values entered on the feeder PIs.

Formula Drivers

This table shows the PIs that are setup to be the drivers for the current formula.


In this example there are two PIs called 'Num' and 'Den' used to calculate a percentage value, each of these PIs, including their current values, are shown in the Formula Drivers table.


Open - this will open the selected PI in a new tab.

Expand All/Collapse All - if you have  PIs with formulas based on PIs with Formulas then the tree will show in this panel.  You can expand this tree using the blue plus icon or by clicking expand all.

Back to Top




Copyright © 2019 Ideagen Sofware. All rights reserved.