If you want to use a formula when you build your own widget, you can either select an existing formula from the Choose data option, or Create a formula from scratch.
Choose data
When choosing an existing formula, you can either select a prebuilt formula from the Formula library, or select a custom formula from the Organisation formulas.
Create a formula
As you build or edit a widget, click Create formula.
In the Row formula builder window:
Enter a Name for the formula
Select a Formula group
Select how you want the data to display, for example, as currency
Select a Variance analysis
Write your formula.
When you're done, click Save.
Your formula will automatically appear within your widget selection and show under the organisation formulas for any future report or forecast.
📌 TIP: For tips on writing formulas, use our guide, Create a formula based prediction.