Sum

Calculate total value of several numeric data

SUM formula is to calculate totals of two or more values

Syntax

Sum(ThisItem.ColumnName1, ThisItem.ColumnName2,...)

ThisItem : The identifier for the current row or record

ColumnName: The column containing the numerical values you want to sum up.

Example

Assume you have a table Product Cost with columns Production Cost, Marketing Cost, and Sale Cost.

Sample data table of Product Cost

Requirement: calculate the total cost for each product.

Formula:

Sum(ThisItem.'Production Cost', ThisItem.'Marketing Cost', ThisItem.'Sale Cost')

Result:

If the formula and data are correct, you can see the value of column 'Total Cost' in where you set to view it in the app.