Using Calculated Field Functions

How to use calculated field functions

When using a calculated field on a form, you can use functions/formulas to build the calculated field. For example, let's say you want to determine the average number of hours spent per month on interior and exterior house inspections. You could create a dynamic table with a calculated field:

Then create a calculated field using the Average function:

Here's an example of how this might look in the app:

The following table provides some functions you can use in calculated fields along with an example of an equation and expected result: