Using the ValueTransform Property (version 23)
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 |
Print this page