| Excerpt | ||
|---|---|---|
| ||
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.
...
| 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 |
...
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.