The calculation widget allows you to create your very own formula. If you have the data, you can calculate it !
This widget uses line, so it's only available for report. You can use the Report row widget to display your results on a dashboard.
How to add the calculation widget
How to add a Calculation widget:
Calculation rules
- When you call a line, always put a $ before the line number.
- The widget follows the classic calculation rules, so use ().
-
The widget doesn't understand the decimal. Here is how to do it ;
I want to take 30% of the line 156987 = $156987*10/7
I want to calculate 30% of the sum of line 239478 and 251469 = ($239478+$251469)* 3/10 - If you calculate an average or a % don't forget to add decimals and the suffix % to the design of your line.
- If the lines in the formula already have budgets, do not add a budget on top of that, the budget will automatically calculate itself.
You don't know how to calculate your KPI, or your formula doesn't react the way you want it? Ask us at support@blent.io !