tableSumIfs

Perform SUMIFS on any table in the model.

tableSumIfs(
    tableName,
    sumColumnName,
    criteriaCol1="", criteria1="",
    criteriaCol2="", criteria2="",
)

Arguments

tableName

The name of the table containing the column to sum. Here you should use a function that ensures that the table exists in the output and returns a table name, like table, excelTable, or csvToTable.

sumColumnName

The name of the column to sum.

criteriaCol1, criteria1, etc.

Optional. See documentation for SUMIFS function.

Examples

Note

Coming soon.