Configuring Formatting in Tables

The Formatting Configuration Format brush. controls the formatting of your report or statement.

Formatting Configuration

You can format the presentation of your report after you have created it by clicking Format brush.. The following options are available in the formatting configuration modal.

  • Column Density. Available options are: Compact, which has less space between table elements, and Comfy, which has more space between table elements.
  • Table Height. Available options are: Small, Medium, and Fit Content.
  • Show Grid. Adds borders to rows in your report. Available options are None [default], All, Total and Subtotal Rows.
  • Ignore Warnings. Available options are: Yes or No. This selection allows you to ignore any warning messages presented on the display table. The ignored messages are not shown in the table view and this selection persists after you close a report and reopen it.
  • Reverse Sign. Displays all negative numbers as positive numbers in your report, and vice versa. To reverse the signs on an individual lens, use the Reverse Sign option available in the Lens Configuration tab.
  • Negative Number Color. You can choose to display negative values in black or red, and whether to prefix these values with a minus, or enclose them in parentheses.
  • Negative Number Format. Available options are: Minus or Brackets. Depending on the selected value negative numbers are displayed either preceded by a "-" sign or in between brackets.
  • Empty Values Format. Available options are: Zero, Blank, or Dash. Selects the format in which empty values are displayed by the table.
  • Divide by Zero Format. Available options are: Error Message, Zero, Blank, or Dash. Selects the format in which divisions by zero are displayed by the table. When selecting "Error Message" the default "#DIV/0!" error is displayed.
Tip: After selecting any changes you want to apply to the report, ensure you click Save in the Table Configuration. This automatically closes the configuration page and reloads your table. To confirm your changes are applied, a prompt is displayed indicating your table configuration has been saved successfully.