Math
The Math stage handles mathematical calculations on a single data row and allows you to conduct a variety of math functions using one or more expressions. Data is input as strings but the values must be numeric or Boolean, based on the type of operation being performed on the data.
- Under Control Stages, click the Math stage and drag it to the canvas, placing it where you want on the flow.
- Connect the stage to other stages on the canvas.
- Double-click the Math stage. The Math Options dialog box appears, with the Expressions tab open. This view shows the input fields, the Calculator, and the Expressions canvas. Alternately, you can click the Functions tab to use functions instead of the Calculator.
The Input fields control lists the valid fields found on the input port. Field name syntax is
very flexible but has some restrictions based on Groovy scripting rules. If you are
not familiar with Groovy scripting, see this website for complete information about
Groovy:groovy-lang.org.
Note: This stage is not available in the tech preview
version of Flow Designer.