Using Calculated Field Functions

How to use calculated field functions

Calculated fields let you automatically perform calculations based on data entered into a form. You can use simple functions or formulas to do things like add values, find averages, or combine text.

For example, if you want to find the average number of hours spent each month on interior and exterior house inspections, you can set up a dynamic table with a calculated field that does the math for you.

Then create a calculated field using the Average function:

Here's how this might look in the app:

See the Functions tab in the Equation window for the complete list of available functions. The following table provides some functions you can use in calculated fields along with an example of an equation and expected result:

Functional	Example Equation	Expected Result
AVERAGE	AVERAGE(23, 36)	30
FLOOR	FLOOR(-3.1)	-4
MAX	MAX([0.1,0.2], [0.4,0.8], [true, false])	0.8
MIN	MIN([0.1,0.2], [0.4,0.8], [true, false])	0.1
POWER	POWER(5, 2)	25
PRODUCT	PRODUCT(5, 15, 30)	2250
ROUND	ROUND(626.3, -3)	1000
ROUNDDOWN	ROUNDDOWN(-3.14159, 2)	-3.14
SIGN	SIGN(-0.00001)	-1
SUM	SUM(-5, 15, 32, 'Hello World!')	42
SUMIF	SUMIF([2,4,8,16], '>5')	24