Difference between revisions of "Writeback and Grid Calculations"
Line 6: | Line 6: | ||
[[File:02 WB Grid calc.png|center]] | [[File:02 WB Grid calc.png|center]] | ||
+ | |||
+ | ===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. |
Revision as of 14:11, 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.