Skip to main content

Scaling

The value produced by a data group can be Scaled using a Formula or limit Conditions.

image3.png

Formula scaling provides three operators with values.

Example: An item contains the flow rate in gallons/minute. To calculate the total flow in MGD perform an average on the item value and then scale with *1440/1000000.

Example: An item contains the temperature in Fahrenheit. To convert to Celsius scale, use the formula

-32*5/9.

Condition scaling provides up to three Limits that provide up to three ways the value can be scaled. The scaling supported are:

  • Specific Value

  • Column Value

  • Column Value that has an applied Formula

Example: When an item value is below 0.001, display the text negligible otherwise show the value.

Example: When an item value is below 100, display blank otherwise scale the value by 1000.

Example: A digital item contains the state of a pump. When the value is less than 0.5 display OFF, otherwise ON.

Example: An item contains the temperature of an oven. Display LOW, MEDIUM, and HIGH at specified temperature thresholds.