SUMX

Description

The SUMX function calculates a value for each row in a table, and then sums the number of calculated values together.

Usage

SUMX(TABLE_EXPR, EXPRESSION)

Example

You can use the SUMX function in a pivot table to count the total number of beneficiaries in a Form containing the list of food distributions. For example, if you had a quantity field in your form with the number of kilograms of food distributed with the code KG_DISTRIBUTED, you could write:

SUMX([Food distributions], KG_DISTRIBUTED)

The second argument can be expression in a row context, for example if we wanted to sum the total number of people receiving distributions by adding the counts from a WOMEN field and a MEN field:

SUMX([Food distribution], MEN + WOMEN))

This measure will calculate the value of MEN + WOMEN for each record in the Food distribution form, and then sum all the results together.

Next item
ADDCOLUMNS