Difference between revisions of "Writeback and Grid Calculations"
(→Step 1: Insert a grid calculation) |
(→Step 2: Insert a grid calculation) |
||
| Line 12: | Line 12: | ||
[[File:04 WB Grid calc.png|500px|center]] | [[File:04 WB Grid calc.png|500px|center]] | ||
| − | ===Step 2: | + | ===Step 2: Name the grid calculation=== |
| − | + | Name the [[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]] | [[File:03 WB Grid calc.png|center]] | ||
| + | |||
| + | Assign the relevabt Excel formula for the grid calculation. | ||
Revision as of 10:28, 10 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
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 "4010 Prof. Services 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"). It can be any Excel formula.
Assign the relevabt Excel formula for the grid calculation.
