Add calculations in tables

You can add your calculated columns to an Anaplan XL table containing any Excel formula.

To add a calculation, right-click a column header and select Add Calculation.

When you enter a calculation in the first cell, it'll automatically fill down. If the calculation references and columns in the table, these will be stored as references to the column.  The calculations continue to work even if the columns are reordered.

In this example, the total value is calculated from two columns retrieved, and the calculated column has been formatted as currency, as described in the formatting section.