Calculation wizard

What is Calculation wizard?

Calculated is used to create logical columns which have predefined formulas. Using Caluculation wizard we can create four columns they are

• Change
  CurrentX - ComparisonX
• Index
  1.0 * CurrentX / ComparisonX
• Percent Change
  100.0 * (CurrentX - ComparisonX) / ComparisonX
• Percent
  100.0 * (CurrentX / ComparisonX)

CurrentX        -> Column using which Calculation wizard was invoked

ComparisonX -> Column chosen in the wizard for comparison