Totals and Total Row For Numeric Fields
If you are using numeric fields from a table as columns in your document table, you can display the total of that column at the bottom. WEP Forms also allows you to create a summary report in a table…
If you are using numeric fields from a table as columns in your document table, you can display the total of that column at the bottom. WEP Forms also allows you to create a summary report in a table format within the document.
For a summary report, you need to specify which field you want to base the report on. If you want to group by multiple fields, you can create a formula field that combines those field values. (For more details, see Grouping Table Records)
For adding total functionality to table there are multiple fields you can use. See table below for these fields and their functionalities. See the example on the bottom this page.
Filed Name | Field Type | Description - How To Use |
Total Fields | Text | List of tables(subtable) numeric field ids will be used for displaying total of. You must separate them with period (“.”). Example: 9.10.12 |
Group Subtotal | Checkbox | If records are being grouped and if this selected then subtotals will be displayed for each group. |
No Grand Total | Checkbox | If you are showing subtotals for each group and if this is selected , it will hide grand total. |
Total Label Column | Numeric | Order # of column that WEP Forms displays total text(label) under. |
Total Label | Text | Label can be static or values can come from table (subtable) field. You can set up subtotal and grand total labels Examples: TOTAL: Subtotal: ~ Total:· If you are using formula field, you need to put field as “~Field ID~”. Formula can be: [Project Phase]&" Subtotal:~Grand Total:" [Project Phase]&" Subtotal:~ [Project Name]&" Total:" |
Total Row Font | Multiple Choice | Different font names are options. You can add/update options. |
Total Row Font Size | Numeric | Use integer numeric value (No decimals) |
Total Row Font Color | Text | Use hexadecimals color values or common color names. Examples: Light Blue, #2a85c6, #4d4dff |
Total Row Background Color | Text | Use hexadecimals color values or common color names. Examples: Red, Light Blue, #2a85c6, #4d4dff |
Total Row Font Style | Multi-Select Text | Options: Bold, Italic and Underline |
Total Label Align | Multiple Choice | Options: Left, Center and Right |
Total Row Align | Multiple Choice | Options: Left, Center and Right |
Example below show total fields' values in WEP Table record under Totals tab.
Totals for table records are being calculated and on document below with values are being displayed with selected properties above.
How did we do?
Grouping Table Records
Table Properties
