Calculate Columns with

Purpose:

The "Calculate Columns in Table" workflow card is used to perform calculations between columns in a selected table. It allows users to select columns, apply a mathematical operation, and store the result in a specified result column.

Components of the Card:

  1. Table Name

    • Description: Specifies the table in which the columns will be calculated.

    • Detail: A dropdown list of all available tables is provided for selection.

  2. Column Name (1st Column)

    • Description: Specifies the first column to be involved in the calculation.

    • Detail: A list of all available columns is provided for selection.

  3. Operation

    • Description: Defines the mathematical operation to be applied between the selected columns.

    • Options:

      • Add (+): Adds the value of the second column to the value of the first column.

      • Subtract (-): Subtracts the value of the second column from the value of the first column.

      • Multiply (*): Multiplies the value in the first column by the value in the second column.

      • Divide (/): Divides the value in the first column by the value in the second column.

  4. Column Name (2nd Column)

    • Description: Specifies the second column to be involved in the calculation.

    • Detail: A list of available columns is provided for selection.

  5. Result Column

    • Description: Specifies the column where the result of the calculation will be stored.

    • Detail: A list of available columns is provided where the calculated value will be saved.

Functionality:

  • Condition Evaluation: The card only executes its action if both the "Where" and "And Sections" evaluate as true.

  • Column Calculation: The card performs the selected mathematical operation between the two chosen columns.

  • Result Storage: The result of the calculation is stored in the selected result column.

Setup and Configuration:

  • Select Table: Choose the table where the columns will be calculated.

  • Choose Columns: Select the first column and second column that will be used in the calculation.

  • Select Operation: Choose the mathematical operation (Add (+), Subtract (-), Multiply (*), Divide (/)) to be applied between the columns.

  • Select Result Column: Choose the result column where the calculation will be stored.

Conclusion:

The "Calculate Columns in Table" workflow card enables users to perform dynamic calculations between columns in a table, and store the results in a designated column. The card offers flexibility to apply different mathematical operations and ensures the result is stored in the specified column.

Last updated

Was this helpful?