gl_excel:callrptvalue

CallRptValue

This function returns the value of a Call Report concept line as of a certain date. The source for this data is the G&B Call Report program (not the G&B GL program).

CallRptValue(Concept,RptDate)

  • =CallRptValue("RIAD4107","12/31/2012") Returns the value for Call Report concept line RCON0010 as of December 31, 2012.
  • =CallRptValue("RCON0010","1/31/2013") Returns the value for Call Report concept line RCON0010 as of January 31, 2013. Note that this is a non-quarter-end date. The Call Report program supports monthly interim reporting. However, the user must first establish values within the Call Report program before they are accessible through this function.

Concept

The 8-character alphanumeric Call Report concept code.

"RCON0010"
"RIAD4107"

%fineprint{Used in: CallRptDescription, CallRptValue}%

RptDate

The month-end date that corresponds to the respective Call Report reporting period. Data must exist in the G&B Call Report program in order for a given date to return values.

"12/31/2013"
 "1/31/2013"

%fineprint{Used in: CallRptValue}%

  • gl_excel/callrptvalue.txt
  • Last modified: 2023/07/24 14:33 UTC
  • by 127.0.0.1