You can add calculations to any Anaplan XL Reporting grid. This will let users make quick calculations that might not be in the cube. These calculations can use any standard Excel formula, from simple sums to complex vlookups, as well as Anaplan XL formulas. They're automatically propagated to all the other cells in the row or column. You can link grid calculations to grid members to respect drilling and swapping dimensions.

Create and manage grid calculations

To add a calculation:

  1. Select Add Calculation option from the grid's right mouse button menu. Alternatively, add grid calculations from the Row Calculation or Column Calculation menus in the grid ribbon.
    An empty calculation is added below the current cell. 
  2. Type the formula into any of the cells. It's propagated to all the other cells in the row or column automatically.
  3. Overtype the title cell to give the calculation a title.
  4. Double-click the title cell to open the Edit Grid Calculation box. You can edit the title, number format, and calculation position.

Delete calculations

You can view, manage, and delete existing calculations in the Anaplan XL > Calculation > Manage Calculations box. You can also select Anaplan XL > Calculation > Delete Calculation from the right-click menu.