Function: sumIf()

Returns the sum of a set of numbers based on a series of corresponding true/false conditions.

Syntax

sumIf(numberList, conditionList)

Argument	Type	Description
numberList	Number Array	An Array containing a list of numeric values
conditionList	Condition List	An Array containing a list of PhixFlow expressions that must evaluate to true or false

sumIf([1,1,1,1], [1,0,1,0])

returns 2.

sumIf(in.Total, in.Include)

If this is applied to the 3 records from the in pipe (the following is pseudo-code used to represent a recordset):

{
	{Total = 32, Include = 1},
	{Total = 20, Include = 0},
	{Total = 15, Include = 1},
}

returns 47.