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. Select the table.

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

   The table opens in edit mode.

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

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

   

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

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.

   

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.

   

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

   

9. Select DONE to close the Calculation tab.