Difference between revisions of "Writeback and Grid Calculations"
| Line 9: | Line 9: | ||
===Step 1: Insert a grid calculation=== | ===Step 1: Insert a grid calculation=== | ||
Define a [[Grid_Calculations|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. | Define a [[Grid_Calculations|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. | ||
| + | |||
| + | [[File:03 WB Grid calc.png|center]] | ||
Revision as of 14:15, 2 October 2023
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.
