Insert difference and percent change
Click here to see this page in full context
  1. Home >
  2. Select and Add Measures >
  3. Insert difference and percent change

 

Insert difference and percent change

In grids that compare two date ranges, you can insert the difference and percent change (i.e., variance).

To insert difference and percent change

  1. Switch to the grid if you haven't already.

  2. To add standard variance calculations (This-Last), place your cursor over the column containing the newer values (i.e., This), and click the menu icon . From the pop-up menu, select Delta, vs. Last. This type of variance calculates the change from the earlier date range to the newer date range; values will be positive if values increased over time.

Tip: To add the difference/percent change between any other values (e.g. This vs. budget), place your cursor over the first subheading in the formula, click the drop-down arrow, and then make your selection.