Do you want to calculate the forecasts for one of your categories using a formula? Here's how to do it!
First, go to the Cashflow plan and click on the cell you want to fill in the table below the graph. 📊
A pane will open on the right of your screen. When you click on Set up formula, click on the field to create your formula 😃
Here is the instruction for the formula in question:
By typing value(), Agicap will take into account the value that is displayed in the field.
By clicking on the Categories button, you will be able to choose your reference category: the one on which your formula is based. (Ex: the calculation of your Suppliers is based on the cash inflows of your Sales category). You can also retrieve the value of a Key Indicator.
You must then indicate the reference month (preceded by a comma). The current month is 0, the previous month -1, and the next month 1.
And finally the calculation: here you can perform different operations, such as multiplication with the * symbol, addition with +, subtraction with -, or division with the / .
⚠ Remember to use dots when using a decimal number (Ex: 0,20 ➡ 0.20).
💡 The following video shows you an example formula:
The forecast for the Supplier category is equal to 30% of the current month's Sales value ➡ We then get the formula: value(categorySales,0)*0.30
💡💡 Nuances are possible: As reference value, you can also choose to take only the forecasts or only the actual. If you want to be an expert on this subject, our article Create a calculation formula will help you out 🐱🏍