Difference between revisions of "Writeback and Grid Calculations"

Line 8: Line 8:
  
 
===Step 1: Insert a grid calculation===
 
===Step 1: Insert a grid calculation===
 +
insert a [[Grid_Calculations|grid calculation]] attached to the member that should trigger the update send to the databse.In this case, we want value of the newly inserted calculation to be updated whenever "4010 Prof. Services Sales"
 +
 +
===Step 2: 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]]
 
[[File:03 WB Grid calc.png|center]]

Revision as of 14:30, 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").

02 WB Grid calc.png

Step 1: Insert a grid calculation

insert a grid calculation attached to the member that should trigger the update send to the databse.In this case, we want value of the newly inserted calculation to be updated whenever "4010 Prof. Services Sales"

Step 2: 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.

03 WB Grid calc.png