We’ll now take the dollar difference of the this month and last month, to see how much performance has improved (or otherwise).
Use the Append Column Toolbar button to add a new column
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
Set the Heading to “$ Change”
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.