Create a Cumulative Formula

Learn to make an amount that is cumulative and display the amount on a chart or use it to reference from another Driver formula

To create a cumulative formula you need to first make a New Line in a Custom Table for the Driver to output the value.

For the aggregation on the New Line be sure to select Ending Balance since the amount is cumulative and you would not want your reports to Sum the amount but rather display the most recent amount.

Once you have the New Line you can then create a Driver formula by clicking on the . . . next to the Cumulative Revenue:

Use Custom Driver if the calculation should be applied only to this particular Plan or Global Driver [GL] if the formula calculation should be applied to all the Active Plans & Actuals. Driver details are shown in the screenshot below:

One thing to be aware of is the Start Date (here: Jan 2024)of the formula and to ensure that you have captured the appropriate period.

Effectively what the formula is doing is the formula Driver is referencing itself by the selection of "Output" with a reference to the range of "Last Month" as seen in the screenshot below.  You then can add on the amount that you are looking to accumulate in the Rate of the formula.

Once this has been completed you can now reference this amount in Dashboard Tiles, Reports, or as part of another Driver Formula for planning purposes.