Skip to main content
This topic describes the syntax, parameters, and usage examples of the SUM function, including how to sum a column of subform data.

Supported Product Scenarios

The SUM function is supported in the following YiDA scenarios:
  • Form (main form fields)
  • Form (business association rules)
  • Form (validation)
  • Workflow design (validation rules)
  • Workflow design (association actions)
  • Integration & automation
  • Workflow node
  • Connector

Format

Attributes

Return Value

Examples

  • Sum multiple Number components. As shown below, use SUM() to calculate the sum of Number 1 and Number 2.
  • Sum a column of subform data. As shown below, use SUM() to calculate the total travel allowance.

Try It Out

Sum multiple Number components, or sum a Number component across multiple subform rows.

Tip

Since no built-in sumif function is available, you can achieve a similar effect as shown below.