Like what you see? Have a play with our trial version.

Error rendering macro 'rw-search'

null

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Follow the instructions below to configure an aggregate a calculated field step:

  1. Expand the Transformation Steps button on the left side of the Transformation Flow builder, to view a list of transformation steps.
  2. Drag the Calculated Field step from the list of transformation steps.



  3. Connect this step to the previous step in the flow. On doing so, it will become configurable.
  4. Click on Add Item.



  5. Use the popup to create a calculated field.



  6. Update the name of the calculated field.
  7. Define your calculation using the buttons at the bottom of the window, for example:
    • Search for the Sum Invoiced Amount field in the -- Select Field -- drop down list and click on it to add it to the formula box.
    • Press the minus ( – ) button.
    • Search for the Sum Cost of Camp field and add it to the formula.
    • You will now have Invoiced Amount - Cost.
    • Test your calculation by using the Validate button. (An error will appear if it is invalid.)



  8. If the calculation is valid, click Save. The data preview panel will display a new column field for the result.



  9. The step's configuration panel will show the newly created calculated field.



  10. You may also edit or delete a calculated field through here.

...