Adding your first Formula
You can create your own custom KPIs and formulas using Futrli’ Formula Builder. Build complex calculations or simply select an individual line – financial or otherwise – to report upon. It’s up to you.
Written by Ross MacLeod
You can create your own custom KPIs and formulas using Futrli’s Formula Builder. Build complex calculations or simply select an individual line – financial or otherwise – to report upon. It’s up to you. In this guide we’re going to create an example Wage to Sales formula.
Add a Card
First you’ll need to add a Card. With the Card in Edit mode, first select the Organisation you wish to use in the Settings tab then select the Report tab. This is where you choose what data displays on the front of the Card:
Locate the Formula Builder
Click the Add Formula button, which will load your Formula Library. You’ll find a list of pre-made Formulas which we’ve given you to start you off. Any Formulas you save to your library will be stored here, allowing you to quickly select them and use them again in your Reports. Clicking the Formula Builder button in the top right will take you to Futrli’s Formula Builder. This is where you can create new Formulas:
Using the Formula Builder
This will load the Formula Builder. Enter the name of your Formula in the Formula Name field. In the search box you’ll find the selected Organisation’s entire Chart of Accounts. Simply select any Chart of Account lines you wish to add to your Calculation and it will be added to your formula:
You can add, divide, subtract and multiply items by selecting the appropriate symbol on the on-screen keyboard or by using the appropriate key on your keyboard. Asterix for multiple, slash for divide, and plus and minus for adding and subtracting:
Select the correct metric
You can select the format of your metric in the Type dropdown. By default, Currency will be displayed. Once happy, click OK to add your Formula to the Card: