Writeback and grid calculations in Anaplan XL Reporting

This is an example of using of grid calculations to write data back to the database.

The example shows how the values for the "4010 Prof. Services Sales" account are automatically calculated as 20% of the one of "4000 Product Sales".

Insert a grid calculation attached to the member that should trigger the update. In this case, we want the values of the newly inserted calculation to be updated when the ones for 4000 Product Sales are entered.

Name the grid calculation with the same name as the existing database member you want to update (here, 4010 Prof. Services Sales).

Assign the relevant Excel formula to the grid calculation.

In the Writeback section of the grid properties dialog, check any grid calculation for which the calculated value should be sent to the database.

Hide the grid calculation so that only the updated database member is displayed.

Now, when values for 4000 Product Sales are saved to the database, the ones for 4010 Prof. Services Sales are automatically calculated and updated as well.