Skip to main content
All CollectionsTreasuryCashflow Plan
Define a forecast with a formula
Define a forecast with a formula
Edgar Renoud avatar
Written by Edgar Renoud
Updated over 2 years ago

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 🐱‍🏍

Did this answer your question?