Skip to main content
All CollectionsReportingBuilding a report
Create a formula in a report
Create a formula in a report

How to create a formula within a report custom widget.

Updated over 4 months ago

When you build your own widget in a report, you need to specify what data you want to appear. You have three data types to choose from:

  • Financial data - anything from your chart of accounts

  • Non-financial data - any Drivers you've added to the organisation

  • A formula - either prebuilt by Futrli, or built by you


How do I create a formula?

  1. As you build or edit a widget, click the Row/Chart formulas dropdown.

  2. Click Create formula.


  3. 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

  4. Write your formula.


  5. When you're done, click Save.

Your formulas appear within the Organisation formulas dropdown, which you can drag and drop to your Rows or Y-Axis.

Did this answer your question?