Write a formula for a KPI
Choose Formula as the measure, give the result a name, and build it by clicking figures and signs or by typing it. A formula can add, subtract, multiply and divide figures and statistics, with brackets. Finconsol refuses a formula that cannot give a true figure, such as one that divides by zero or adds a balance to a flow.
Build a formula
- In the component editor, choose Formula as the measure.
- Enter the Name of the result, such as Revenue per employee.
- Choose how the formula is written: Build by clicking, or Type a formula.
- Add the figures and the signs. The editor reads the formula back and lists the figures that match what you type.
What a formula can hold
- Figures from the statements, cash flow, your chart and your statistics.
- Plus, minus, times and divide, brackets, and a minus sign in front of a figure.
- Up to 20 figures and 300 characters.
When you type a formula, start typing a name to pick a figure, then type the signs and brackets yourself. In click mode, Group the selected steps puts brackets round the steps you choose.
Four extra steps
- Average of month ends for a balance or statistic taken at a date.
- A year earlier for the same figure twelve months before.
- Only above nil shows a figure only when the result is above zero, and words you choose when it is not.
- Days in the period for a figure in days.
When a formula is refused
Finconsol does not show a figure that cannot be true. It refuses a formula, and says why, when:
- a bracket is not closed, or two signs are next to each other
- it divides by zero
- it adds a balance to a flow, mixes units, or counts the same figure twice
- it puts a ready-made ratio, such as gross margin, inside a formula. Use the ratio as the measure, or write it from its parts.
Calculation rows in custom reports work in a similar way. Calculation and statistic rows covers them.