How to add field calculations to the table footer

This functionality requires the GravityMath plugin version 2.0 to be installed and activated on your website.

Introducing in version 2.0 of GravityMath, there's a new functionality that allows our users to easily perform calculations (Lowest, Highest, Average, Sum, and others) to an entire column of the View without having to write the [gravitymath] shortcode.

We will be starting with a very basic form and View containing only two types of fields: a Single Line Text and a Number field.

Table with columns: Name, Age. Footer: sum of Age, field types labeled

Now, let's calculate the Lowest age in that View.

1) On the View editor, click the cog icon to access the Age field modal screen:

Fields for entries with gear icons to configure "Name" and "Age" fields in a table

2) Once the field configuration modal appears, click on the option "Add field calculations to the table footer?":

Checkbox option to add field calculations to a table footer

3) That checkbox, once clicked, shows three additional options:

Checkbox to add field calculations, options for label, source, and calculation type

3.1) "Label" allows us to write a custom text to show up on the table footer. Let's try "The youngest age is:"

Checkbox for adding field calculations with label input for displaying results in table footer 3.2) "Calculation Source" defines where the data will come from.

3.3) "Calculation Type" allows us to select which calculation we are going to perform with the values of that field (column).

Here's the final output in our View:

Table with names and ages; footer shows calculation, "The youngest age is: 22"

We can also perform other calculations, like a sum of all ages:

Checkbox for adding field calculations to table footer, with options for label and calculation type as sum

Table showing names and ages, footer calculates total age as 83