Math

Contents[Hide]

The Math transform lets you perform simple math functions such as Absolute, Round, and Square Root on numeric input columns. It is similar to the String transform except that it offers math functions instead of string functions.

The following functions are available:

  • Round
  • Absolute
  • Ceiling
  • Floor
  • Truncate
  • Square Root
  • Multiply by 100

Transform - Math
Transform - Math

Tip
You can also apply formula functions by using a Calculated Element transform.

1. Input

The Math transform requires one input transform that has one or more numeric columns.

2. Add the transform

To add this transform to an existing data cube process, first select the connection link between two connected transforms.

Go to the toolbar, click Insert Common, and then select Math.

Select connection link and insert the transform
Select connection link and insert the transform

The Math transform is inserted between the two transforms.

Math transform is inserted
Math transform is inserted

3. Configure the transform

Double-click the Math transform or select the Configure option from its right-click menu.

In the configuration dialog for the transform, decide which input column you want to apply a math function on, and then click the column's Edit icon. Also uncheck any columns that should be excluded from the output.

Edit a column if you want to apply a Math function
Edit a column if you want to apply a Math function

In the Transform Element dialog, use the dropdown to select the Math function you want (e.g., Round). Then click the submit button at the bottom of the dialog.

You can apply math functions to more than one numeric column with a single transform.

Select a Math function to round off LineTotal values
Select a Math function to round off LineTotal values

4. Output

The output of the Math transform consists of the columns that were checked, where the values in each numeric column with a math function selected are changed.

Click the Process Result transform and open the Data Preview to see the output of the transform.

Output of Math transform shows LineTotal values have all been rounded
Output of Math transform shows LineTotal values have all been rounded

5. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri