SUM_BY_DATE
Sum a list of numbers in a datasource by date range
Example Usage
SUM_BY_DATE("TimecardSource", "REG", "2021-09-07", "2021-09-14", "PayDate")
SUM_BY_DATE("TimecardSource", "REG"). // using defaults
Overview
Function signature
SUM_BY_DATE(datasource, field, startdate, enddate, datefield)
Category
Math
Return data type
float
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
datasource | list | Data to iterate over | |
field | string | Field to sum in each row in data | |
startdate | date | Starting date | |
enddate | date | Ending date | |
datefield | string | Field within each row to examine for passing dates |