Add cell references in dynamic tables
You can reference values from one dynamic table into another. This eliminates the need to manually enter the same value multiple times in different tables in the financial statements.
To add cell references:
-
Wählen Sie die Tabelle aus.
-
Select More actions (
), then choose Edit Dynamic Table.
Die Tabellenoptionen im Bearbeitungsmodus.
-
Go to the desired cell and select the fx icon.
Note: The cell must be an Input row or Input column cell.
-
In the Calculation dialog, select Insert data (fx).
-
The Data Link dialog opens. Select the Cell Reference tab.
-
In the Select area/note drop-down, select from the list of available areas or notes to reference.
-
In the Select dynamic table field, search for a table in the financial statement area or note, or select a table from the list below.
-
In the dynamic table preview, select the applicable cell to reference.
-
Select DONE to close the Calculation tab.