Formulas
Last updated
Last updated
Formulas can be used to perform basic mathematical operations and derive measurements based on the current values of other fields.
At the moment, the supported operations are +, -, * and /.
You can use both static expressions as well as other fields in your formula. For example, to calculate a measurement in celsius based on another field that holds the value in Fahrenheit, you would use the formula (TEMPERATURE_F - 32) * (5/0), where TEMPERATURE_F is the field identifier of the Fahrenheit-field.
Defining a formula is very simple. Simply select one or more fields from the "Available Placeholders" list that should provide measured values for the conversion. Use this line also to enter the operations.
You can use a formula to combine the measured values of different fields and perform calculations based on these values. This is suitable, for example, for setting up compound values or conditions, where the processing of several measured values is required.
The following screenshot shows a newly created field and its configuration dialog including the formula for the conversion of a Celsius output value of another field into the unit Fahrenheit.
Each time a new value is being recorded to the TEMPERATURE field, the formula is executed and the result (temperature in Fahrenheit) is written to the TEMPERATURE_F field.
