How to use
Compare previous and current values or actual versus target. See absolute change, relative percentage change, percentage points and a monthly trend with calculation steps.
The Percentage Variance / MoM Change Calculator measures business performance differences: what changed, by how much, and in which direction. Here “variance” means a performance difference or target gap. Statistical variance has a separate meaning; this tool does not calculate statistical variance.
Choose Quick Compare for previous versus current or Target versus Actual. Choose Monthly Trend to enter two to twenty-four periods. Select Number, Currency or Percent, and Auto, 1, 2 or 3 percentage decimals. Currency codes affect display only, with no exchange-rate conversion. Results update in page memory. Copy summary or Copy result uses deterministic text; if clipboard access fails, selectable copy text appears.
Reset keeps the active main mode but restores Revenue, Currency USD, 2 decimals, Previous Month comparison, the default quick values and Jan–Apr rows, and closes calculation details. Refresh clears edits and opens Quick Compare. Defaults are previous 125000, current 142500 and target 150000; monthly defaults are Jan 100000, Feb 112000, Mar 108000 and Apr 127000.
Percentage change formula
Percentage change = ((Current − Previous) / Previous) × 100. The previous value is the reference denominator. With a positive previous value, a positive result means an increase and a negative result means a decrease. Direction arrows and words additionally describe the actual Current − Previous difference.
For 125,000 to 142,500, the difference is 17,500; 17,500 / 125,000 × 100 = 14%. Display precision changes rounding only; calculations use the accepted numeric values.
Absolute vs percentage change
Absolute change: Δ = Current − Previous. It keeps the original metric units: dollars, orders or percentage points. Relative percentage change divides this difference by the reference value. A gain of 100 from 1,000 is 10%, while a gain of 100 from 10,000 is 1%. When values are identical, absolute and relative changes are zero unless the reference is zero, when the percentage remains undefined.
Month-over-month change
MoM means month-over-month: each month is compared with its immediately preceding month. MoM % = ((CurrentMonth − PreviousMonth) / PreviousMonth) × 100. The first row is a starting period and has no MoM percentage. Labels may represent other consistent periods, but this workspace is presented as Monthly Trend.
Target vs actual
Target percentage difference = ((Actual − Target) / Target) × 100. Absolute difference = Actual − Target. With a positive target, a positive gap is above target, a negative gap is below target and zero matches the target. The same signed formula is used for negative targets, with a caution because relative signs can differ from above/below position. A zero target has no defined relative percentage.
Percentage points vs percent change
A percentage-formatted metric requires two distinct outputs. From 4% to 5%, the relative change is (5 − 4) / 4 × 100 = +25%, while the absolute change is +1 percentage point (+1.00 pp at default precision). Do not call the latter a +1% relative change. For target 10% and actual 9%, the relative gap is −10% and the percentage-point gap is −1 pp.
For a separate business model, explore a monthly churn scenario with its own customer, revenue and time assumptions. Churn and percentage variance are not interchangeable measures; distinguish relative percentage changes from percentage-point changes when interpreting rates.
Zero starting values
Percentage change can’t be calculated from a zero starting value. A zero denominator makes the relative rate undefined, including 0 to 0. The absolute difference is still calculated. In Monthly Trend, a previous value of zero makes only the following transition’s relative rate undefined. Undefined rates are excluded from the arithmetic mean and extrema; a zero first value also makes overall relative change undefined.
Negative values
Percentage change from a negative starting value can be misleading depending on the metric. Review the absolute change alongside the percentage. The formula keeps the signed denominator; it never substitutes its absolute value. For −100 to −80, Δ = +20 and relative change = 20 / (−100) × 100 = −20%. The value increased even though the mathematical relative rate is negative. Neutral summaries disclose this distinction, including negative targets.
Monthly trend analysis
Overall change = ((Last − First) / First) × 100, alongside the absolute last-minus-first change. Average MoM change is the arithmetic mean of valid month-to-month percentage changes. It includes valid zero and negative rates and excludes undefined rates. It is not CAGR or compounded growth.
Largest increase is the maximum strictly positive valid MoM percentage; largest decrease is the minimum strictly negative valid MoM percentage. When no such rate exists, the calculator says “No increase recorded” or “No decrease recorded.” Ties use the earliest transition. With negative starting values, these labels describe signed relative percentages rather than necessarily the absolute direction.
The single line chart shows period values with markers, a padded automatic scale and a text equivalent. For readability, up to four shortened labels appear on the x-axis; full labels and values remain in the text equivalent and table. Y-axis numbers use a disclosed scale multiplier. The monthly table can scroll horizontally inside its own region on small screens.
Worked examples
Revenue increased 14%
Previous 125,000; current 142,500. Δ = 142,500 − 125,000 = 17,500. Percentage = 17,500 / 125,000 × 100 = 14%. The default result is +14.00%, with +$17,500 absolute change.
Actual finished 5% below target
Target 150,000; actual 142,500. Difference = −7,500. Percentage = −7,500 / 150,000 × 100 = −5%. The result is −5.00%, below target by $7,500.
Conversion rate: percentage points and relative change
Previous 4%; current 5%. Relative change = (5 − 4) / 4 × 100 = +25%. Percentage-point change = 5 − 4 = +1 pp. The current rate is 5%, not 29% or 4.25%.
Zero starting value
Previous 0; current 100. Absolute change is +100. Relative percentage change is undefined because the starting denominator is zero; division by zero is not performed.
Four-month revenue trend
Jan 100,000; Feb 112,000; Mar 108,000; Apr 127,000. MoM rates are +12%, −3.5714285714% and +17.5925925926%. Overall change is +27%. Their arithmetic average is approximately +8.6737213404%. Apr has the largest increase and Mar the largest decrease.
Assumptions and limitations
Use comparable periods, units and metric definitions. This calculator does not adjust seasonality, inflation, accounting changes or currency conversions, and does not judge whether a rise or fall is desirable for a particular KPI. It does not forecast outcomes or infer business causes.
Numeric fields accept at most 64 characters. Values must be zero or finite with absolute value from 1e−9 through 1e15. Proper comma or single-space thousands grouping, decimal values and optional K/M/B suffixes are supported; unsuffixed scientific notation is also accepted. K = 1,000, M = 1,000,000 and B = 1,000,000,000. Malformed or ambiguous suffixes are rejected. Percent mode optionally accepts a trailing %; entered 4 means 4%. Currency symbols are display output, not input syntax.
Metric names are limited to 64 characters and period labels to 24; blank labels become Metric or Month N. Labels render as text. Inputs and derived results use IEEE-754 numbers, so floating-point rounding is possible and display precision is not a claim of measurement accuracy. Tiny nonzero results use scientific notation to avoid displaying a false zero. There are no saved accounts, history or persisted inputs.
To distinguish nominal change from an inflation scenario, compare a value in today's purchasing power separately using compatible time periods and explicit inflation assumptions. The variance result itself remains unadjusted for inflation.
FAQ
How do I calculate percentage change?
Subtract the previous value from the current value, divide by the previous value, then multiply by 100: ((Current − Previous) / Previous) × 100. The starting value must be nonzero.
What is month-over-month change?
Month-over-month (MoM) compares one month with the immediately preceding month. A positive-base increase has a positive relative rate; an absolute direction indicator shows whether the value rose or fell.
What is the difference between absolute change and percentage change?
Absolute change is Current − Previous in the metric’s units. Percentage change expresses that difference relative to the previous value. They answer different questions and should be reviewed together.
What happens if the previous value is zero?
The percentage is undefined because its denominator is zero. The calculator still shows the absolute change and excludes that undefined rate from the average and largest-change statistics.
Can percentage change be calculated with negative values?
Yes, with a nonzero negative denominator, the documented formula produces a mathematical result. Its sign can differ from the actual direction: −100 to −80 increases by 20 but gives −20%. Review the visible caveat and absolute change.
What is the difference between percent change and percentage points?
A change from 4% to 5% is +1 percentage point and +25% relative change. Select Percent to see both; entering 4 or 4% means a metric value of 4%, not 0.04%.
How do I calculate variance from a target?
Use ((Actual − Target) / Target) × 100. The denominator is the target, not the actual value. A zero target gives an undefined relative gap, while the absolute actual-minus-target difference remains available.
How is average MoM change calculated?
Add all valid month-to-month percentage changes and divide by their count. Zero-base undefined transitions are excluded; valid zero and negative rates are included. If none are valid, the average is undefined.
Is average MoM change the same as compound growth?
No. Average MoM change is an arithmetic mean, not CAGR or a compounded growth rate. It does not account for the multiplicative sequence of changes. Overall change separately compares the first and last values.
How many months can I compare?
Monthly Trend accepts two to twenty-four periods. Labels may be up to 24 characters, including Jan, Q1 or Week 1. Use consistent periods and measurement definitions so the comparison is meaningful.
Sources
Reviewed October 2, 2026. OpenStax explains percent increase/decrease using the original value as the reference. NIST/SEMATECH clarifies the separate statistical meaning of variance as a measure of spread. Our business “variance” means performance difference; the sources do not endorse BuzCalculator. Row limits, display precision and parser bounds are product conventions.