Run rate template

The rule that you can create from the Runrate template calculates the run rate, or average account value in the source scenario. Then, the rule populates the accounts in a destination scenario by copying the computed value to selected periods.

You might use a run rate calculation to forecast company performance over time, based on selected results from current scenarios. For example, if a company has revenues of $120 million in the most recent quarter, a company representative might say, "Our latest results put us at a $480 million run rate."




This rule has SQL implementation. To run a rule with SQL implementation, you can run the rule directly from Planning Business Modeler, or include the rule as part of a scheduled job.

Placeholder substitution requirements

To convert the Runrate template into a business rule, you must substitute actual dimension values for the placeholders in the templates. For information about how to substitute values, see Filling a placeholder in a rule template.

The following table describes the placeholder substitutions that you must make to create a business rule from this template.

Placeholder Comment


Destination scenario for storing calculated averages


Start period in the destination scenario


End period in the destination scenario


Starting period from which run rate is calculated


The ending period from which run rate is calculated


Source scenario for calculating run rate

See Also