Percentage Change Calculator
Percentage Change is evaluated from Original Value and New Value. The calculation reports Percentage Change, Absolute Change and Direction.
Results
About the Percentage Change Calculator
The calculator uses a multi formula configuration. Each reported value is read as a direct evaluation of the stored rules with the declared field formats and units.
Formula basis:
Percentage Change = ((New Value - Old Value) / |Old Value|) x 100
Interpret the outputs in the order shown by the result fields. Optional inputs affect only the outputs that depend on those variables.
Formula & How It Works
The calculation applies the following relations exactly as recorded in the metadata: Percentage Change = ((New Value - Old Value) / |Old Value|) x 100 Each output field is produced by substituting the supplied inputs into the relevant relation and then applying the declared rounding or text format.
Worked Examples
Example 1: Salary Raise
Inputs
With Original Value = 55,000 and New Value = 61,600 as the stated inputs, the result is Percentage Change = 12%, Absolute Change = 6,600 and Direction = Increase. Each value corresponds to the declared output fields.
Example 2: Stock Price Drop
Inputs
With Original Value = 148.5 and New Value = 121.77 as the stated inputs, the result is Percentage Change = -18%, Absolute Change = -26.73 and Direction = Decrease. Each value corresponds to the declared output fields.
Example 3: Home Price Appreciation
Inputs
With Original Value = 320,000 and New Value = 374,400 as the stated inputs, the result is Percentage Change = 17%, Absolute Change = 54,400 and Direction = Increase. Each value corresponds to the declared output fields.
Example 4: Calorie Reduction
Inputs
With Original Value = 2,800 and New Value = 2,100 as the stated inputs, the result is Percentage Change = -25%, Absolute Change = -700 and Direction = Decrease. Each value corresponds to the declared output fields.
Common Use Cases
- Calculate price increase from last year
- Find salary raise percentage
- Determine stock return percentage
- Compare year-over-year revenue growth