Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Excerpt
hiddentrue

sumIf(list) Returns the sum of a set of numbers on the condition that all the values are either null or valid Numbers.


Function: sumIf()

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

...

ArgumentTypeDescription
numberListNumber ArrayAn Array containing a list of numeric values
conditionListCondition ListAnĀ Array containing a list of PhixFlow expressions that must evaluate to true or false

...

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

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

returns 47.

See Also