Add Formulas to fields

Formula in Number response type is used to automatically calculate values based on inputs from other fields. This is particularly useful for maintenance metrics like efficiency, operational performance, or usage calculations.

For example, a formula calculates the valve efficiency by dividing the valve output by the input, using previously recorded values such as flow rate and pressure.

To add a formula to field:

  1. Enter a task or question as Calculate Valve Efficiency.
  2. Select the Number value from the Responses drop-down.
  3. Select the Required check box if the value is required.
  4. Select the Unit. For example, meter (m), centimeter (cm), liter (l), Celsius (oC), and so on. For more information, see Number with the Unit of Measurement.
  5. Select the History check box and add readings.
  6. Click the Formula link.
  7. In the Add Formula editor, add calculations and click Save.
    Figure 1. Add Formula


    The configured formula is applied to the respective field and the calculated values are updated dynamically.

    In this editor, you can,
    • View the list of tasks or questions and use them to add formulas.
    • Click the Operator tab to select simple mathematical operations such as Addition, Subtraction, Multiplication, Division, Exponentiation, and so on.
    • Click Adv to see the advanced options such as π, e, x y, √, & %.
    • Click the Functions tab to select complex mathematical functions such as RoundUp, RoundDown, and so on.
      Figure 2. Add complex formula


    • Use the previous readings (history) of the field in the formula and make the field read-only by selecting Read-only on the top right.