Video guide 3 of 12 · Your KPIs · 1:42
Calculated KPIs in SimpleKPI
How to have SimpleKPI work a KPI out from others, with Gross Profit as the example.
What this guide shows
- Choose Calculated under More Options, then open Create a formula.
- Pick the KPIs the formula uses and put the operators between them, as you would in a spreadsheet: Revenue minus Cost of Sales.
- Choose By frequency for values that add up month by month, or By total for a ratio such as a margin.
- Turn on Calculate this target and the formula works out the target too.
- On KPI Data the calculated row fills itself in and follows the KPIs behind it.
Transcript
What's said in the video, by chapter. Press a time to play from there.
Why calculate
Some KPIs are worked out from others: a margin, an average sale, a gross profit. You don't have to type those in. SimpleKPI can calculate them. We'll build a formula, choose how it adds up over time, set its target, and watch it fill itself in.
Build the formula
Add a KPI and name it: gross profit. Under More Options, choose Calculated, then open Create a formula. Press Add a KPI to pick the KPIs it uses. Type a few letters, and choose revenue. Then press minus, and add cost of sales the same way. Revenue minus cost of sales: it works just like a spreadsheet formula.
Frequency or total
Next, how it's worked out over longer periods. By frequency works it out for each month, then adds them up. By total adds up the KPIs first, then works it out once. Gross profit adds up month by month, so choose frequency. For a ratio, like gross margin, choose total.
Its target
Its target can be calculated too. Turn on Calculate this target, and the formula works out the target as well. Or leave it off, and type your own.
See it work
Save, and on KPI Data the new row fills itself in. Nobody types it, so nobody mistypes it. When revenue or costs change, gross profit follows.