Tips, Answers & Solutions for Frequently Asked Questions about Custom Tables
This article elucidates the frequently asked questions related to Custom Tables and offers insights on maximizing the efficacy of Custom Table utilization:
- Section's Subtotal
- Cannot "Save Changes" Custom Table issue
- Section Cloning
- Period Value Impact on Dashboards & Reports
- Moving Lines & Sections
Section's Subtotal
Adding Subtotal to the Section summarizes all the Lines, Reference rows, and Sections that are included under it.
To add the Subtotal of the Section, navigate to Settings ⚙️> Custom Tables > click on the ellipsis (. . .) to the left of the Section and choose + Add Subtotal:
Be Aware:
- You cannot add the Subtotal of the Section that includes different Lines' Format. In other words: The Format for all the Lines within the Section must be identic. In this case, the "SAVE CHANGES" button will be greyed out so you will not be able to save the Custom Table adjustments successfully
- You cannot add the Subtotal of the Section that includes different Lines' Period Values. In other words: the Period Values for all the Lines within the Section must be identic. In this case, after saving the Custom Table changes, you will get the System Health Error and the Subtotal Section will be highlighted in red under the Plan area
Cannot "Save Changes" Custom Table issue
Several potential factors may prevent the successful saving of a Custom Table, causing the "SAVE CHANGES" button to appear greyed out. The most common reasons are:
- Not unique Sections and Lines' Names
Each Section and Line's Name within the same Custom Table must be unique:
To resolve the above issue, modify the Name of one of the Lines/Sections or add a distinguishing character to ensure they are unique.
- Section with the Subtotal added includes Lines with different format
To solve the above issue adjust the Number (#) Format to the Money ($) Format so all the lines' Formats added under the Opportunity Pipeline ($) Section incl. the Subtotal will be consistent.
Did you know?
Lines containing errors, that prevent the Custom Table from being successfully saved, are highlighted in orange to facilitate easy identification:
Section Cloning
A Section included the Custom Table can be cloned:
- within the same Custom Table by clicking on the ellipsis (. . .) to the left of the Section > Clone (Section cloned within the same Custom Table will be displayed below the Section that is cloning with the suffix "Cloned" at the beginning of the Name)
- to another Custom Table by clicking on the ellipsis (. . .) to the left of the Section > Copy to Table (Section cloned to another Custom Table will be allocated at the top of that Custom Table)
Be Aware:
- It is not possible to clone the total Custom Table
Period Value Impact on Dashboards & Reports
Each Line's Period Value determines the aggregation of data over time in Dashboards & Reports and can be set up as follows:
- Beginning Balance: take the first value in the period (e.g. Balance Sheet accounts such as Cash)
- Ending Balance: take the first value in the period (e.g. Ending Customers count)
- Sum: add up all the values in the period (e.g. Income Statement accounts such as Revenue)
- Average: take an average of all the values in the period (e.g. percentages such as Net Retention Rate)
As demonstrated in the below screenshots, the Period Value can be utilized to accurately identify the number of Reps at the End of the Month in the Reports area:
When Reps End of Month's Period Value is adjusted from Ending Balance to the Sum, the Total column will display the sum of Reps End of Month for July - December 2024:
Moving Lines & Sections
The order of Lines and Sections within the Custom Table can be fully customized. Once the structure of the Custom Table is established, adjustments can be easily made by clicking on the ellipsis (. . .) to the left of the Line or Section and selecting the Move button. You can then drag the Section or Line to the desired position.
Did you know?
Lines can be moved not only within the same Section, they can be also moved to another Section of the same Custom Table.