0

Using the ValueTransform Property (version 22)

  • updated 2 yrs ago

The 'ValueTransform' property of a control can be used to convert the current tag value using an expression. The keyword, value, is used as placeholder for the actual value within the expression. For example...

  • value*10
  • Truncate(value)
  • Pow(value,3)

Calculations are performed using the C# NCalc library. Below are the available operators and functions.

Operators

Logical Operators

or, ||, and, &&

Relational Operators

=, ==, !=, <>, <, <=, >, >=

Math Operators

+, -, *, /, %

Bitwise Operators

& (and), | (or), ^ (xor), << (left shift), >> (right shift)

Unary Operators

!, not, -, ~ (bitwise not)

Functions

Name

Description

Usage

Result

Abs

Returns the absolute value of a specified number.

Abs(-1)

1

Acos

Returns the angle whose cosine is the specified number.

Acos(1)

0

Asin

Returns the angle whose sine is the specified number.

Asin(0)

0

Atan

Returns the angle whose tangent is the specified number.

Atan(0)

0

Ceiling

Returns the smallest integer greater than or equal to the specified number.

Ceiling(1.5)

2

Cos

Returns the cosine of the specified angle.

Cos(0)

1

Exp

Returns e raised to the specified power.

Exp(0)

1

Floor

Returns the largest integer less than or equal to the specified number.

Floor(1.5)

1

IEEERemainder

Returns the remainder resulting from the division of a specified number by another specified number.

IEEERemainder(3, 2)

-1

if

Returns a value based on a condition.

if(3 % 2 = 1, 'value is true', 'value is false')

'value is true'

in

Returns whether an element is in a set of values.

in(1 + 1, 1, 2, 3)

TRUE

Log

Returns the logarithm of a specified number.

Log(1, 10)

0

Log10

Returns the base 10 logarithm of a specified number.

Log10(1)

0

Max

Returns the larger of two specified numbers.

Max(1, 2)

2

Min

Returns the smaller of two numbers.

Min(1, 2)

1

Pow

Returns a specified number raised to the specified power.

Pow(3, 2)

9

Round

Rounds a value to the nearest integer or specified number of decimal places.

Round(3.222, 2)

3.22

Sign

Returns a value indicating the sign of a number.

Sign(-10)

-1

Sin

Returns the sine of the specified angle.

Sin(0)

0

Sqrt

Returns the square root of a specified number.

Sqrt(4)

2

Tan

Returns the tangent of the specified angle.

Tan(0)

0

Truncate

Calculates the integral part of a number.

Truncate(1.7)

1

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular