125,000 is the example result. This model reports an absolute gap. It removes the sign, so compare the original inputs to distinguish a shortfall from an excess.
Find the absolute distance between current revenue and the revenue target. The result removes the sign, so check which input is larger.
Turning the revenue target into a measurable sales workload
This model reports an absolute gap. It removes the sign, so compare the original inputs to distinguish a shortfall from an excess. Pipeline planning joins deal value, conversion and time. The model should use opportunities that meet a defined qualification stage, rather than every contact in the CRM. Deal concentration matters when a few large accounts dominate an average.
Source and result record
For revenue gap, retain Revenue target, Current revenue together with the output. Record the date of the source values and the unit convention used in the form. That record separates a change in the underlying case from a change in how the information was entered. A saved result without its source values cannot show which assumption produced it.
Example with the supplied inputs
Revenue target: 500000; Current revenue: 375000. Result: 125,000. The values are illustrative.
Compare one changed input
Revenue target changes from 500000 to 550000. The result becomes 175,000. All other inputs remain fixed.
Calculation rule
Absolute gap = absolute value of (target or ending value − actual or starting value).
Inputs and output
| Input | Example value | Entry convention |
|---|---|---|
| Revenue target | 500000 | Use revenue target on the currency and period basis shown by the formula. Keep gross amounts, net amounts and unit amounts distinct; the page does not fetch a price or exchange rate. |
| Current revenue | 375000 | Use current revenue on the currency and period basis shown by the formula. Keep gross amounts, net amounts and unit amounts distinct; the page does not fetch a price or exchange rate. |
Output: 125,000 is the example result. This model reports an absolute gap. It removes the sign, so compare the original inputs to distinguish a shortfall from an excess. Use the formula to distinguish a cash amount, count, percentage or ratio.
How to use the page
Collect the inputs
Gather Revenue target, Current revenue. Use one period and the units shown in the form.
Run the calculation
Enter the values and select the action. The calculation rule above explains how the inputs produce the result.
Compare a scenario
Change Revenue target on its own, keeping the other inputs fixed. Read both results before changing another assumption.
Worked example
With the example inputs listed above, the result is 125,000.
Change Revenue target from 500000 to 550000 while keeping every other value fixed. The result becomes 175,000. This comparison isolates that input; it does not forecast how other variables will respond.
Check the stated formula, units and limits before using the result in a decision.
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026