Sum column

Sum up the values of a particular column from all child rows that satisfy some condition

Ingredient Family: summarizationIngredients

Outline Display: Sum up {{columnName}} values that satisfy {{condition}}

Local scope

The parent slot binds these (look up the slot in the parent to see how):

• $resultTable – The table to store the summaries
• $table – The table to summarize

Settings

Required

• sumField : column of $table (type filter: any type)
  The column to sum. This column must have a numeric type.

• columnName : new column (type: type of sumField)
  The name for this summation field

Optional

• condition : formula (returns bool; required, non-nullable)
  The condition for whether we should use a given row in our summation
  Scope: all columns of $table (reference as [ColumnName], e.g., [Name], [Price])