Difference

Description

The result of subtracting one number from another.

Calculation Editor

Options

Input Parameter Values Input Values
Only Rollup If Generic Criteria

Input

Operation Input Values Required
+ or - sign toggles when selected Column or Literal ✔
+ or - sign toggles when selected Column or Literal ✔

Remarks

  • If the difference calculation is used from the Design > Calculations window, you will need to manually the second operation to a - sign to ensure a difference calculation is being performed rather than a sum.
  • The Difference and Sum calculations are identical in nature and can be used interchangeably.

Example

  1. Input: Actual Amount (100), Budget Amount (90)
  2. Quick Calculations > Math > Difference
  3. Output: 10