Formulas help you automate the computation of forecast values in specific categories. They are applied across all scenarios, bank accounts, and periods from the current period onwards.
Important Concepts to keep in mind:
One Formula per Category: You can have only one formula assigned to each category.
Date Range: A formula's date range starts from the current period (offset 0) into future periods. It does not depend on the selected period.
Global Application: Formulas are applied to all offsets, scenarios, and bank accounts. To create distinct formulas for specific scenarios or banks, combine formulas with manual KPIs.
Retention of Past Values: Deleting a formula does not remove previously computed values. You will need to manually delete them or create another forecast to overwrite them.
Managing Formulas
Creating a Formula
Access the Category: Click on the cell of the desired category in your cashflow table.
Open the Side Panel: This will open the side panel on the right.
Navigate to Forecast Section: Click on the Forecast section within the side panel.
Set Up Formula: Click on the Set up formula button to access the formula settings.
Enter Your Formula: In the formula editor, input your custom formula using the correct syntax.
Validate: Click Validate to apply the formula. The formula will compute values from the current period to future periods.
Editing a Formula
Access the Formula: Click on the category cell to open the side panel, and navigate to the Forecast section.
Edit Formula: Click on the existing formula to open the formula editor.
Modify the Formula: Make the necessary changes to your formula.
Validate Changes: Click Validate to save changes. The formula will update values from the current period onwards.
Deleting a Formula
Access the Formula: Open the side panel by clicking on the category cell, and go to the Forecast section.
Delete Formula: Click the Delete formula button.
⚠️ Note: Deleting the formula does not remove values that were previously computed. You need to manually delete these values from the cells or create another forecast to overwrite them.
Avoiding Syntax Errors
To find out how to write a form on Agicap, please consult this article.
Decimal Numbers: Use points
.instead of commas,when writing decimal numbers.
Incorrect:3,5→ Error:unexpected token ","
Correct:3.5Function Arguments: Use commas
,instead of semicolons;in functions likeIForMAX.
Incorrect:IF(condition; value_if_true; value_if_false)→ Error:unexpected token ";"
Correct:IF(condition, value_if_true, value_if_false)Parentheses and Arguments: Always close parentheses
()and provide all required arguments in functions.
Error:unexpected end of fileNesting Limits: Avoid nesting too many fields inside a formula. Excessive nesting is not supported.
💡 Tips
Check Syntax Carefully: Small syntax errors can prevent formulas from working. Always double-check your use of commas, semicolons, and parentheses.
Test Formulas: Before relying on a formula, test it to ensure it produces the expected results.
Q&A❓
Can I have multiple formulas in one category?
No, each category can have only one formula. If you need multiple calculations, consider combining expressions within a single formula or restructuring your categories.
How do I apply a formula to a specific scenario or bank account?
Formulas are global and affect all scenarios and bank accounts. To target specific scenarios or accounts, use manual KPIs in conjunction with your formulas.
What happens to past forecast values when I delete a formula?
Deleting a formula does not remove the forecast values that were previously computed. You need to manually delete these values or create a new forecast to overwrite them.