Edit

Column Calculations

We’ll now take the dollar difference of the this month and last month, to see how much performance has improved (or otherwise).

  1. Use the Append Column Toolbar button to add a new column
  1. Open up the Column Settings of the new column and set the Column Type to Calculation

This indicates that this column will be based on the values of other columns or MoneyWorks variables

  1. Set the Heading to “$ Change”
  1. Type “Col3-Col4” into the Formula, and click OK

COL3 and COL4 are the column names (not to be confused with the column titles). These appear in the top of each column, and are used to reference the column.

  1. Preview the report, closing when finished