Writeback and Grid Calculations
From version 2308.1 FluenceXL supports the use of Grid calculations for writing data back to the database.
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").
Contents
[hide]Step 1: Insert a grid calculation
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.
Step 2: Name the grid calculation
Name the grid calculation with the exact 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.
Step 3: Specify that the grid calculation should be used for writeback
In the "Writeback" section of the grid properties dialog, check any grid calculation for which the calculated value should be sent to the database.
Step 4: Hide the grid calculation
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.
