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.
Related Topics
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com