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.

csvFileName

The name of the CSV file (including the extension) from which to read data.

sumColumnName

The name of the column to sum.

query

An optional query to be applied to the table. See SQL queries for details.

criteriaCol1, criteria1, etc.

Optional. See documentation for SUMIFS function.

Examples

Note

Coming soon.