Writeback and Grid Calculations

From version 2308.1 FluenceXL supports the use of Grid calculations for writing data back to the database.

Using an Excel formula with a grid in writeback mode

In the below example, we want the values for the "4010 Prof. Services Sales" account to be automatically calculated as 20% of the one of "4000 Product Sales").

Step 1: Insert a grid calculation

Define a grid calculation with the exact same name as the existing database member you want to update (here , "4010 Prof. Services Sales"). It can be any Excel formula.