.png?height=120&name=OmniByte%20-%20PNG%20Black%20Logo%20Oct%202021%20(1).png)
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 how this might look in the app:
See the Functions tab in the Edit Calculated Field 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 |