Formulas are used to generate graphs and tables from accounting data, budget data and own key figures.
General use
Below is a general description of how you can create your calculations that are shown in the graph. Just so you know, it is raw data that is shown, which can sometimes give unexpected results. If something is shown as a negative value when it should be positive, you can quickly "reverse" the value by putting a minus sign before the variable.
Balance accounts
Use [ and ] to get values from balance accounts (account numbers 1000 to 1999):
- An account, example: [1000]
- A range, example: [1000-1999]
- Multiple accounts and ranges, for example: [1000-1799,1900-1999]
Profit and loss accounts
Use { and } to get the change for income accounts (account numbers 3000 to 8999):
- One or more individual accounts, for example: -{3001,3010}
- A range, for example: -{3000-3999}
- Multiple accounts and ranges, for example: -{3001,3010-3799,3900-3999}
Negative and positive values
In the sie4 file, values are stored opposite to what we usually think of them. An income account's value, e.g., 3041, is therefore negative even though it is income. Correspondingly, an expense is stored as a positive value.
To "reverse" the values, you, therefore, need to write a minus sign in front of the accounts. For example:
- -{3000-3999} returns all revenue accounts summed as a positive number
- -{4000-4999} gives all direct cost accounts as a negative number
- -{3000-7999} gives the result (EBIT) as positive if the result is positive, otherwise negative
Arithmetic calculations
You can use the usual arithmetic operations (addition, subtraction, multiplication and division) as well as parentheses in formulas, for example:
(-{3000-4999})/(-{3000-3999})
The above gives the gross margin ie the account gross profit (which is the sum of all accounts between 3000 and 4999) divided by the revenue (the sum of all accounts between 3000 and 3999). Then enter % as the unit to get the percentage.
Using variables
Variables can either:
- Defined by a formula
- Be Boardeaser's predefined financial ratios
- Be the organization's own uploaded key figures
Regardless of the type of variable, variables can be used in formulas.
Example:
- R1 is a predefined variable for Net Sales (Account 3000 to 3799)
- employees is a separate key figure loaded into Boardeaeser
- oms_employ is a variable created in Boardeaser through the formula R1/employees
Based on this, you can get a graph with net sales per employee only by specifying "oms_employ" as the data source. If you don't want to create that variable, you can get the same graph by entering "R1/employees".