How It Works
Each rule-based projection is made up of four parts:
• Lookback period — how far back from the projection date the data window starts. Setting this to 12 months means the window begins 12 months ago.
• Duration — the length of the lookback window. A lookback of 12 months with a duration of 3 months looks at the 3-month window that started 12 months ago.
• Filter dimensions — narrows the data by customer, vendor, account, or any other relevant dimension. At least one filter is required.
• Amount formula — choose sum or average, then apply a percentage. Use a value above 100% to project growth, or a negative value to reverse the sign.
Creating a Rule-Based Projection
1. Click the Add Projection button.
2. Toggle the Rule-based amount switch next to the amount input field.
3. The Amount Rule section will appear. Set your lookback period, add at least one filter dimension, and choose your amount formula.
4. Fill in the remaining fields as you would for a regular projection.
Common Examples
Rolling average — lookback 6 months, duration 6 month, filter by expense account, formula: average. Automatically calculates each period based on recent activity.
Carry forward last month — lookback 1 month, duration 1 month, formula: sum. Carries last month’s actual value forward as the projection.
Percentage of revenue — filter by income accounts, formula: sum at your target rate (e.g. 21%). Projects costs like materials or commissions based on revenue.
Same month last year + growth — lookback 12 months, duration 1 month, formula: sum at 110% for 10% growth. Ideal for seasonal businesses and annual planning.
