When creating a metric it is possible to ‘calculate’ values for the Actual and Threshold Values for the metric. During create metric dialogue, after you have selected the Scoring Type you will see a dialogue box like this:
Towards the centre of this box are three drop-down menus currently displaying the word ‘Manual’. This indicates that the values for these items will be ‘Manually’ entered into the system. Should you wish to perform a calculation on any of these items the click on the drop-down and select ‘Calculated’ to create a calculated metric.
(For information on other parts of this dialogue refer to the Quick Start guide – Creating Metrics)
If you select Calculated from the drop-down menu, a ‘Next’ option will appear at the bottom to take you to an additional dialogue screen like this:
This part of the dialogue provides the opportunity to ‘calculate’ a metric Value based on other metrics in the system. This is similar to the way you might calculate a value in a ‘cell’ in a spreadsheet. Each metric has a unique identifier; this is used in the calculation. The calculation box is at the top. Many different types of calculations can be defined.
Defining a Calculation
For example, if this new metric was “Number of items in knowledge base less industry templates”, to subtract the ‘Number of industry templates’ from the ‘Number of Items in the knowledge base’, the equation would be M(15) – M(17). This would be arrived by doing the following:
Click on ‘Number of items in the knowledge base’ and click Add
Click on the ‘ – ‘ sign button
Click on ‘Number of industry templates’ and click Add
When you have completed your equation, click on Finished. You will notice that the metric will now be described as ‘calculated’.
There are a large number of operands that can be used in the calculation box:
IMPORTANT NOTE: When using the operands below, you may need to use a double = (e.g. ==) when checking for an ‘equal’ value. A distinction has to be made between ‘assigning’ a value (=) and comparing a value (==).
The following chart denotes the operational symbols to use within QuickScore:
Year to Date Calculated Metric
To create a YTD metric, the equation has to take the form: “TD(Yearly,nnn)” where “Yearly” is the name of your annual calendar and nnn is the metric ID.
There are a couple of things to note with this equation:
- It only works on Number or Currency data types (not percentage)
- It only works with Aggregation Type = Sum
- It is usually used with an Unscored scoring type metric
- If you use a scored type e.g. RAG, then you will need to calculate the thresholds as well
- It is based on a calendar type, if you need a custom calendar YTD, you will have to define this in Administration
Using Initiative Values in a Scorecard Metric’s Equation
A calculated metric can reference many different values attributed to an Initiative/Task/Milestone. When setting a Calculated Metric’s equation field, the following formula is used to reference Initiative/Task/Milestone values:
I([Acronym],[ID]) For [ID],
substitute in the Initiative/Task/Milestone ID value. This is found on the Initiative/Task/Milestone > Overview screen in the top left corner.
For [Acronym], substitute in the appropriate acronym as found in the list below:
- BSTD – Budget Spent to Date
- BR – Budget Remaining
- TB – Total Budget
- PTB – Projected Total Budget
- PBV – Projected Budget Variance
- PBVP – Projected Budget Variance Percentage
- PC – Percent Complete
- PTE – % Time Elapsed
- PSV – Projected Schedule Variance
A real-‐world example: I(TB,1001) where “TB” is the acronym for Total Budget and 1001 is the Action Plan’s ID value.
End of Calculated Metrics