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:

  1. Wählen Sie die Tabelle aus.

  2. Select More actions (), then choose Edit Dynamic Table.

    Die Tabellenoptionen im Bearbeitungsmodus.

  3. Go to the desired cell and select the fx icon.

    Note: The cell must be an Input row or Input column cell.

    The fx icon displays on the left margin of the cell.

  4. In the Calculation dialog, select Insert data (fx).

  5. The Data Link dialog opens. Select the Cell Reference tab.

  6. In the Select area/note drop-down, select from the list of available areas or notes to reference.

    The Select area/note drop-down on the Data Link page.

  7. 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.

    The Select dynamic table search field on the Data Link page.

  8. In the dynamic table preview, select the applicable cell to reference.

    The dynamic table preview pane on the Data Link page.

  9. Select DONE to close the Calculation tab.