If you're an Agicap pro and have already explored all the nooks and crannies of the tool, you know that you can create formulas to calculate forecast or set up key indicators! 🎯
To create formulas, simple or complex, here is all the information you need:
🔹 How to make a formula ❓
To call a value in a formula, here is the syntax: Key Word(Identifier,period)
The keyword
You can use:
the value of the cell in the table (keyword "value") - it includes the realized + the committed + the remainder to be done on an objective
the value of the achieved/paid only (keyword "paid")
the value of what remains to be done to reach the goal only (keyword "remaining")
the value of the forecast only (keyword "objectives") - these are the forecasts you have defined on your cashflow plan
the value of the expected only (keyword "expected") - these are the invoices pending payment that you have created or imported via your flow matrix
On your cashflow plan, this is what these keywords correspond to:
The identifier
Just pick your desired category or indicator as a reference.
The period
You will then need to define what period to take this value from in relation to the current period. For this, think of a timeline: the current period is at 0. The previous period is at -1, the next period at 1.
The period is the frequency of calculation of the objectives chosen: it can therefore represent days, weeks, months depending on what you have set up on your Cashflow plan.
Now that you know how to call values, all you have to do is create formulas!
Calculation symbols
You can use all the following calculation symbols:
"+" to add
"-" to subtract
"*" to multiply
"/" to divide
Formulas
As in Excel, you can make formulas! Here are some examples:
Average(value 1, value 2) to calculate an average
Max (value 1, value 2) to calculate the maximum value
Min (value 1, value 2) to calculate the minimum value
If (condition, value to return if true, value to return if false)
You can also use a number of other formulas available in Excel, don't hesitate to test them or send us a message if you have any doubts !
🔹 Example
If you expect your turnover to grow by 2% per month, compared to the turnover of the previous month for "Customer A", here is what the formula would look like : value(category name is "Customer A",-1)*1.02
💡 Good to know: If you want to use decimals in your formulas, use periods "." instead of commas ","
💡 Good to know: Always click on the "Refresh computation" to apply your changes.
If you have any doubt, contact us on the chat so we can guide you! 😊