Evaluate Expressions
- 19 Jan 2024
- 1 Minute to read
- Print
- DarkLight
Evaluate Expressions
- Updated on 19 Jan 2024
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Step Details | |
Introduced in Version | 7.12.0 |
Last Modified in Version | 8.18.0 |
Modification Details | Added a new property to change the output of the step to "Double" data type, |
Location | Data > Numbers |
The Evaluate Expression step is used to solve a defined algebraic expression. The step achieves this by automatically creating input for characters representing the numeric variables in the Expression. This can be helpful for people in fields such as banking or engineering, where they may need to evaluate a custom formula with data values from another step.
These steps use NCalc expressions. For more information, see NCalc.
Properties
Inputs
Property | Description | Data Type |
|---|---|---|
Use Double Precision | Changes the step output type from Decimla to Double data type. | Boolean |
Expression | Write expressions in the Expression column; any variable will be available as input. | String |
Outputs
Property | Description | Data Type |
|---|---|---|
Result | Result of the Expression. | Decimal |
Related Information
Example Labs:
Rounding Decimals Using Dynamic Expression Step
Forum Posts:
Expression List
NAME | DESCRIPTION | USAGE | RESULT |
|---|---|---|---|
Abs | Returns the absolute value of a specified number. | Abs(-1) | 1M |
Acos | Returns the angle whose cosine is the specified number. | Acos(1) | 0d |
Asin | Returns the angle whose sine is the specified number. | Asin(00 | 0d |
Atan | Returns the angle whose tangent is the specified number. | Atan(0) | 0d |
Ceiling | Returns the smallest integer greater than or equal to the specified number. | Ceiling(1.5) | 2d |
Cos | Returns the cosine of the specified angle. | Cos(0) | 1d |
Exp | Returns e raised to the specified power. | Exp(0) | 1d |
Floor | Returns the largest integer less than or equal to the specified number. | Floor(1.5) | 1d |
IEEERemainder | Returns the remainder resulting from the division of a specified number by another specified number. | IEEERemainder(3, 2) | -1d |
Log | Returns the logarithm of a specified number. | Log(1, 10) | 0d |
Log10 | Returns the base 10 logarithm of a specified number. | Log10(1) | 0d |
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) | 9d |
Sign | Returns a value indicating the sign of a number. | Sign(-10) | -1 |
Sin | Returns the sine of the specified angle. | Sin(0) | 0d |
Sqrt | Returns the square root of a specified number. | Sqrt(4) | 2d |
Tan | Returns the tangent of the specified angle. | Tan(0) | 0d |
Truncate | Calculates the integral part of a number. | Truncate(1.7) | 1 |
In | Returns whether an element is in a set of values. | in(1 + 1, 1, 2, 3) | true |
If | Returns a value based on a condition. | if(3 % 2 = 1, 'value is true', 'value is false') | 'value is true' |
Feature Changes
Description | Version | Developer Task |
|---|---|---|
Added a new property to change the output of the step to "Double" data type, | [DT-039671] |
Was this article helpful?
