SUM_TO_CURRENT
Sum a list of numbers in a datasource up to the current row using a startdate
Example Usage
SUM_TO_CURRENT("TimecardSource", "REG", "2021-09-23", :"PayDate")
SUM_TO_CURRENT("TimecardSource", "REG"). // using defaults
Overview
Function signature
SUM_TO_CURRENT(datasource, field, startdate, datefield)
Category
Math
Return data type
float
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
datasource | list | Datasource to iterate over | |
field | string | Data field to sum | |
startdate | date | Date to start adding | |
datefield | string | Date field to examine per row |