Purpose


The column setting allows you to choose a formula to calculate the totals in the footer and set the text alignment.



Description

When configuring the button with the SEARCH action or configuring the TableGrid component, it is possible to select a formula to calculate the total in the desired column.

The following formulas are available to calculate the total:

  • none - no formula
  • Sum - sum calculation
  • Count - row count
  • Average - arithmetic mean
  • Maximum - maximum value
  • Minimum - minimum value
  • Distinct - counting the number of unique values



In this example, choose the formula Sum, which subtracts the sum of all values in the column. In addition, you can specify any text both before and after the total value.



The result of the setting, will be the total values in the footer of the table component.