Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

To perform math operations, you can use the set transform to the Edit column with formula transformation to update values in a column based on a math operation. The following transform transformation multiplies the column by 10 and adds the value of colB:

...

Add Selective Values from One Column into Another

You can use the set transform to the Edit column with formula transformation to perform math operations based on a condition you define. In the following step, the Cost column is replaced reduced by 10% if the Qty column is more than 100. The expression is rounded down to the nearest integer, so that the type of the column (Integer) is not changed:

...