Using Calculations

Creating a calculation formula

We will generate a simple example of a calculation using two Number fields. 

  1. Add 2 different number fields and name them First Number and Second Number.
  2. Add a third Number field which will handle the result of the calculation. Name it Total.  Ensure that this field is positioned after the first two Number fields.
  3. Access the field settings of the Total field.
  4. Access the field settings of the Total field. Click the button Insert Merge Tag and select your first field in the calculation.
  5. Add a mathematical operator. In this case, simple addition (+).
  6. Insert the Second Number field to complete the calculation.
  7. Your calculation is all set. Be sure you Save your form.

+2+35Addition Operator
3-21Subtraction Operator
/4/22Division operator 
*4*28Multiplication Operator 
pipi3.14Math constant pi
ee2.71Math constant e
modmod(3,2)1Modulus Operator 
floorfloor(5.95)5Returns the largest integer less than or equal to a given number.
roundround(5.5)6 Returns the value of a number rounded to the nearest integer.
minmin(4,3,5,36)3Returns the number with the lowest value.
maxmax(4,3,5,36)36Returns the number with the highest value.
avgavg(10,20,60)30 Its value can be obtained by calculating the sum of all the values in a set and dividing the sum by the number of values.
absabs(-3)3Returns the absolute value of a number
randomrandom(100,999)e.g: 342Returns a random number
sqrtsqrt(16)4Returns the square root of a number
sinsin(0)0Returns the sine of a number.
coscos(o)1 Returns the cosine of the specified angle, which must be specified in
ifif(1>3,1,2)2It allows you to make logical comparisons between a value and what you
switchnumber =21
4The function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. pro
powpow(2,3)8Power function with two operator pro
daysdays(2022-12-20,2021-11-06)409Days Between Two Datespro
monthsmonths(2022-12-20,2021-11-06)13Months Between Two Datespro
yearsdays(2022-12-20,2021-11-06)1Years Between Two Datespro