This function requires the Financials and KPI-Analytics add-ons.
Variables in Boardeaser can be created in three ways:
- Predefined variables based on the sie4 files that are uploaded. Read more here.
- By downloading the KPI template, create a key figure as a variable and enter the data for each time interval. Read more here.
- By entering a formula that includes accounts and/or KPI variables.
This article describes the last option of the above. The variables created in this way can be used in graphs and tables, i.e. in the same way as account variables and key figure variables.
Create variable
Go to Finance > Analyze > Variables and click “New variable”.
Select variable
Either start from the formula for an existing variable or create a completely new formula. If you want to start from an existing variable, click "Select variable" and select the one you want to start from. The formula is then displayed in the "Formula" field.
Define variable
Regardless of whether you start from an existing variable or create a new one, you then enter the name (NOTE: the name must only contain letters between a-z and _, i.e. no å ä ö or spaces), description and unit. If you click "Private", you are the only user who can see the variable.
Formula
Click the field under "Formula" to enter the formula. Just like when creating graphs and tables, you can use the usual calculations and other variables when creating your new variable. Read more about formulas here.
Under the "Formula" field, the data that the formula provides is displayed. When you are done, click "Save", and the variable will be saved.
Now you can use the variable when creating graphs and tables!
Example
Create a variable that contains all revenue accounts:
- Name: total_revenue
- Formula: -{3000-3999}
Explanation: revenue accounts are accounts between 3000 and 3999. Entering 3000-3999 will sum all revenue accounts. Angle brackets {} are used to show change or month. Revenues are stored as negative values in the sie4 file, but usually you want them as positive values, so you need to put the minus sign first.