Table Outputs
A Table Formula Output presents information in a structured grid containing text and calculated values.
Use a Table when a result is better communicated as a breakdown across multiple rows or columns rather than as a single Output.
Examples include:
cost breakdowns;
benefit categories;
annual projections;
departmental results;
scenario comparisons;
itemised calculations.
Adding a Table Output
From Components, under Outputs, select:
Table Formula Output
A new Table starts with a basic row and column structure that you can configure for your model.
Editing Table Data
To edit the structure and contents of a Table, select:
Expand the settings to edit table data
This provides access to the rows, columns and calculations that make up the Table.
Table Columns
Each Table column can be configured as:
Text
Equation
A Text column contains manually entered text.
An Equation column contains calculated values.
For each column you can configure:
Name
Type
Width (%)
Prefix
Suffix
Decimal
Alignment
Alignment can be:
Left
Center
Right
The column Name is displayed as the heading at the top of the column.
You can add additional columns or remove existing columns.
At least one column must remain in the Table.
Changing a Column Type
Changing an existing column between Text and Equation clears the existing contents of the cells in that column.
Review any existing information before changing the column type.
If you need to retain the existing values, record them before making the change and then recreate the required content using the new column type.
Table Rows
Rows contain the individual values displayed beneath your configured columns.
You can:
add rows;
delete rows;
edit Text cells;
create calculations in Equation cells.
At least one row must remain.
Rows cannot currently be manually reordered from the Table editor.
Equation Cells
Equation columns allow individual cells to contain calculations.
Each Equation cell can have its own Formula.
Table calculations can reference eligible:
Inputs;
Outputs.
This allows different rows within the same Table to perform different calculations.
For example, a benefits Table could contain separate rows for:
productivity savings;
cost avoidance;
labour savings;
revenue improvement.
Each row could calculate its value using different Inputs and supporting Outputs.
Formula References
Table Equation cells can reference eligible Inputs and Outputs from the ROI Model.
However, Tables have some important calculation restrictions.
A Table cannot reference:
another Table;
a Chart.
A Table also cannot itself be used as a Formula source by another component.
Use a Standard, Card or Gauge Formula Output when a calculated result needs to become an input to further calculations elsewhere in the model.
Table Formula Validation
Ekphrastic validates Equation cells before allowing the Table to be saved.
If an Equation contains a Formula error, you may see:
Please confirm the formula on table.
Review the Equation cells and correct the invalid Formula before saving.
Dynamic Rows
Table Formula Outputs support Dynamic rows.
Dynamic rows allow the number of visible Table rows to be controlled by the value of another eligible Input or Output.
Enable Dynamic rows and select:
Row count from
The selected value determines how many of the configured rows are displayed.
For example, if a Table contains ten configured rows and the controlling value is:
4
the first four rows are displayed.
Rows that are not currently displayed remain part of the Table configuration. They are not deleted.
How Dynamic Row Counts Work
The value selected through Row count from is treated as a whole-number row count.
The number of visible rows cannot exceed the number of rows already configured in the Table.
For example, if the Table contains six configured rows and the controlling value is 10, the Table can display only the six rows that exist.
Dynamic rows therefore control the visibility of configured rows rather than automatically generating unlimited new rows.
Dynamic Row Validation
When Dynamic rows is enabled, a Row count from source must be selected.
The Table cannot be saved if Dynamic rows is enabled without a controlling source.
If the Table does not need a variable number of rows, disable Dynamic rows.
Formatting Columns
Table columns provide formatting controls including:
Prefix
Suffix
Decimal
Alignment
Unlike Standard and Card Formula Outputs, Table columns do not provide dedicated Currency or Percentage format selectors.
Use Prefix and Suffix where a displayed value requires a currency symbol, percentage symbol or other unit.
Formatting Individual Cells
Individual Table cells can also have their own presentation settings.
Use the ⋯ control on a cell to access the available formatting options.
These include:
Prefix
Suffix
Decimals
Font weight
Text alignment
Tooltip
Text colour
Cell background
Apply the changes to update the selected cell.
You can also reset the cell formatting.
Cell-level formatting is useful when a particular result needs different presentation from the rest of its column.
Table Display Settings
In addition to the Table's rows and columns, you can configure presentation settings including:
Display Label
Display Detail
Display Icon
background colour
tooltip
tooltip colour
Visibility Condition
Use the Display Label and Display Detail to explain what the Table represents and provide any context needed to interpret its values.
Conditional Visibility
A Table Formula Output can use a Visibility Condition.
This allows the Table to appear only when the configured condition is met.
If Visibility Condition is enabled, make sure the required source has been selected before saving the Table.
For more information, see Conditional Visibility.
Calculate on Hidden
Table Formula Outputs do not provide Calculate on Hidden.
This differs from Standard, Card and Gauge Formula Outputs, where calculation behaviour while hidden can be configured separately.
Attached Resources
Table Formula Outputs do not support Attached Resources.
If supporting evidence or collateral needs to be associated directly with a calculated result, use a supported component such as:
Std Formula Output;
Card Formula Output;
Dynamic Value Text.
See Attached Resources for more information.
Changing the Component Type
Table Formula Outputs cannot be changed into another component type using:
Swap component type
Likewise, Standard, Card and Gauge Formula Outputs cannot be converted directly into a Table.
If a different presentation is required, create the appropriate component instead.
When to Use a Table
Use a Table when:
several related results need to be shown together;
individual values need clear labels;
a calculation requires an itemised breakdown;
users need to compare values across rows or columns;
exact values are more important than a visual trend.
If the relationship between values is more important than the individual numbers, consider using a Chart instead.
For a single calculated result, a Standard, Card or Gauge Formula Output will usually be more appropriate.
Tips
Use clear column names so users can understand the Table without additional explanation.
Use Text columns for descriptions and Equation columns for calculated values.
Review existing cells before changing a column type because their contents will be cleared.
Configure enough rows before using Dynamic rows.
Use cell-level formatting selectively to highlight important values.
Remember that Tables cannot be referenced by other Formulas.
Resolve all Equation errors before saving the Table.
Last updated