Channel formulas

The Channel Formulas Manager enables organizations to create and manage formulas that convert raw sensor signals, such as pulse counts, 4–20 mA current, resistance or 0–10 V voltage, into meaningful measurement values (e.g., wind speed, flow rate, visitor count). This allows you to use virtually any type of analog or pulse-based sensor with Efento Cloud while preserving compatibility with platform features such as charts, alarms, reports, and webhooks.

The Channel Formulas Manager is located in the Organization settings and is available to users with Administrator or Manager permissions.

The main list shows all formulas created within the Organization, along with their names, access levels, and available actions. From this view, you can:

  • Add a new formula

  • Review change history (e.g., modifications, creator, date)

  • Edit an existing formula

  • Delete a formula, provided it is not in use

  • Check which sensors are using each formula

Creating a new formula

Creating a formula includes two stages: defining general properties and specifying conversion logic.

1

General settings

When adding a new formula, you must:

  • Enter a unique formula name: Choose a clear name describing the transformation, such as “Voltage to Pressure”.

  • Define source and target types The source type specifies the type of data received from the sensor, while the target type determines the measurement type that will be produced after the formula is applied. Select both types from the list of available measurement types.

    If you need to use a measurement type that is not supported natively in Efento Cloud, create a custom measurement type first. Once created, it will appear in the list and can be selected as the target type for the formula.

  • Set the formula’s access level:

    • Private – Only the creator can edit it.

    • Public – Any user with access to the Formula Manager can modify it.

2

Defining logical conditions and conversion expressions

Each formula is built from one or more conditions, allowing highly flexible transformations. A condition contains:

  • A logical range specifying when the condition applies

  • A conversion formula that transforms the raw sensor value

Using mathematical expressions

All formulas use X to represent the incoming sensor reading. Examples:

  • Convert milliamps to temperature: X * 12.5 - 25

  • Scale a voltage reading: (X / 10) * 100

  • Convert a pulse count into liters based on a pulse factor: X * 0.5

Mathematical rules supported:

Operator
Meaning

+

Addition

-

Subtraction

*

Multiplication

/

Division

( )

Grouping

Conversion expressions must be valid equations and no longer than 32 characters.

After completing the condition and conversion formula, add the formula by pressing '+' in the Actions column, which will display the formula condition below, ready to be saved.

Building multi-condition formulas

You can define multiple conditions within a single formula. For example:

  • If X < 10 → apply X * 2

  • If X = 10 → apply X * 3

  • If X > 10 → apply X * 4

This supports advanced use cases such as:

  • Non-linear sensors

  • Pulse counters with different ranges

  • Sensors requiring multi-step calibration curves

After entering a condition and formula, click + to add it to the list. Conditions are evaluated in order and the first matching condition is used. Each condition formula can be edited (pencil icon), deleted (trash bin icon), or reordered using the up and down arrow buttons to adjust its position in the list.

Assigning formulas to sensor channels

Formulas can be assigned to sensors that provide electrical or pulse-based outputs, such as:

  • 4–20 mA industrial sensors

  • 0–10 V analog sensors

  • Resistance sensors

  • Pulse-output devices (e.g., flow meters, counters)

Assigning formulas during device setup

When adding a sensor to the platform:

  1. Enter the sensor name

  2. Enable Channel redefinition

  3. Select the target measurement type for the selected sensor channel(s)

  4. Choose an existing formula, or create a new one

Once the sensor is added:

  • You may change formulas only within the same target measurement type

  • To change the target type, you must remove and re-add the device

This ensures data consistency and prevents accidental loss of measurement history.

Formula errors

Efento Cloud automatically validates every converted measurement. If a problem occurs, the platform displays a Channel error message next to the sensor on the dashboard.

Possible causes include:

  • Division by zero

  • Value outside the allowed measurement range defined in the measurement type

  • Sensor reading does not match any condition

  • Incorrect or invalid formula syntax

To view details about the error, hover your cursor over the red Formula error indicator.

Last updated