Calculated Attribute Formats
Format | Summary | Example |
---|---|---|
+ | Returns the sum of two numeric operands. (Addition) | {0} + {1} ~ 0:1, 1:4 = 5 |
- | Returns the difference of two numeric operands. (Subtraction) | {0} - 4 ~ 0:10 = 6 |
* | Returns the product of two numeric operands. (Multiplication) | {0} * {1} ~ 0:2, 1:3 = 6 |
/ | Returns the quotient of two numeric operands. (Division) | {0} / {1} ~ 0:9, 1:3 = 3 |
and | Indicates whether both operands are true. | {0} < 10 and {0} > 0 ~ 0:5 = True |
or | Indicates whether either or both operands are true. | {0} < 2 or {0} >5 ~ 0:8 = True |
not | Returns true if the logical operand is false. | not ({0} < 0) ~ 0:-5 = False |
= | Indicates whether the left operand is equal to the right operand. | {0} = 4 ~ 0:4 = True |
!= | Indicates whether the left operand is not equal to the right operand. | {0} != {1} ~ 0:2, 1:4 = True |
< | Indicates whether the left operand is less than the right operand. | {0} < 0 ~ 0:2 = False |
<= | Indicates whether the left operand is less than or equal to the right operand. | {0} <=2 ~ 0:2 = True |
> | Indicates whether the left operand is greater than the right operand. | {0} > 0 ~ 0:8 = True |
>= | Indicates whether the left operand is greater than or equal to the right operand. | {0} >= 5 ~ 0:10 = True |
if | Returns a value based on a condition | if ( {0} % {1} = 0, ‘Yes’, ‘No’ ) ~ 0:4, 1:2 = Yes |
in | Returns whether an element is in a list of values. | in ( {0}, {1}, {2}, {3} ) ~ 0:7, 1:4, 2:7, 3:9 = True In the example above, the first declared argument '{0}' is the value you want to evaluate, in this example, the number '7' as defined by the '0:7' after the (~). |
Round | Rounds a value to the nearest integer or specified number of decimal places. | Round( {0}, 2) ~ 0:3.1415 = 3.14 |
Floor | Returns the largest integer less than or equal to the specified number. | Floor( {0} ) ~ 0:1.5 = 1 |
Ceiling | Returns the smallest integer greater than or equal to the specified number. | Ceiling( {0} ) ~ 0:1.5 = 2 |
Truncate | Calculates the integral part of a number. | Truncate( {0} ) ~ 0:3.14 = 3 |
Abs | Returns the absolute value of a specified number. | Abs( {0} ) ~ 0:-1 = 1 |
Min | Returns the smaller of two numbers. | Min( {0}, {1} ) ~ 0:-4, 1:23 = -4 |
Max | Returns the larger of two numbers. | Max( {0}, {1} ) ~ 0:5, 1:8 = 8 |
Sqrt | Returns the square root of a specified number. | Sqrt( {0} ) ~ 0:4 = 2 |
Pow | Returns a specified number raised to the specified power. | Pow( {0}, 2) ~ 0:3 = 9 |
Exp | Returns e raised to the specified power | Exp( {0} ) ~ 0:0 = 1 |
Log | Returns the logarithm of a specified number. | Log( {0}, 10) ~ 0:1 = 0 |
Log10 | Returns the base 10 logarithm of a specified number. | Log10( {0} ) ~ 0:1 = 0 |
Sign | Returns a value indicating the sign of a number. | Sign( {0} ) ~ 0:-10 = -1 |
Sin | Returns the sine of the specified angle. | Sin( {0} ) ~ 0:0 = 0 |
Cos | Returns the cosine of the specified angle. | Cos( {0} ) ~ 0:0 = 1 |
Tan | Returns the tangent fo the specified angle. | Tan( {0} ) ~ 0:0 = 0 |
Asin | Returns the angle whose sine is the specified number. | Asin( {0} ) ~ 0:0 = 0 |
Acos | Returns the angle whose cosine is the specified number. | Acos( {0} ) ~ 0:1 = 0 |
Atan | Returns the angle whose tangent is the specified number. | Atan( {0} ) ~ 0:0 = 0 |