RPTAMTSUM

Sums the reported amount within a range of dates.

Formula Syntax

RPTAMTSUM("RptAmtName", StartDate, EndDate, MatchType)

"RptAmtName": the name of the Reported Amount that is being analyzed. This name must be enclosed in quotes.

StartDate: starting date for which the reported amounts are to be summed.

EndDate: ending date for which the reported amounts are to be summed.

MatchType: choose from the following:

  • 0: includes amounts within the date range based upon each Reported Amount's effective date.
  • 1: includes amounts within the date range based upon each Reported Amount's stop date.
Examples

RPTAMTSUM("HOURS", DATE(1,1,2015), DATE(12,31,2015), 0): sums hours with effective dates between 1/1/2015 and 12/31/2015.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com