Next revision | Previous revisionLast revisionBoth sides next revision |
gl_excel:lineaverage [2010/06/18 19:01 UTC] – created mwolfe | gl_excel:lineaverage [2010/12/22 20:26 UTC] – [Optional Parameters] mwolfe |
---|
This is the user report line average balance function. It returns the daily average balance for a user report line during a given month. | This is the user report line average balance function. It returns the daily average balance for a user report line during a given month. |
| |
Currently, the LineAverage balance function cannot be called with a separate StartDate the way that the [[AvgBal]] function can. | %InlineCode{LineAverage(UserRpt, LineCode, AvgBalDate, //Company//, //PosNeg//, //StartDate//)}% |
| |
%InlineCode{LineAverage(UserRpt, LineCode, AvgBalDate, //Company//, //PosNeg//)}% | |
| |
==== Example Usage ==== | ==== Example Usage ==== |
* %InlineCode{=LineAverage("BALCON", "A01", "3/17/2009", , "C")}% Returns 'Debit Balance' because the daily average balance for line A01 of the BALCON user report during the month of March 2009 is a debit balance and the "C" in our formula told Excel to only display the balance if it was a credit. See below for more information about the PosNeg parameter. | * %InlineCode{=LineAverage("BALCON", "A01", "3/17/2009", , "C")}% Returns 'Debit Balance' because the daily average balance for line A01 of the BALCON user report during the month of March 2009 is a debit balance and the "C" in our formula told Excel to only display the balance if it was a credit. See below for more information about the PosNeg parameter. |
* Note the extra comma between the AvgBalDate and the PosNeg parameter. That must be included because the Company parameter is not specified. | * Note the extra comma between the AvgBalDate and the PosNeg parameter. That must be included because the Company parameter is not specified. |
| * %InlineCode{=LineAverage("BALCON", "A01", "6/30/2009", , , "1/1/2009")}% Returns the daily average balance for line A01 of the BALCON user report during the first two quarters of 2009. |
==== Required Paramaters ==== | * Note the two extra commas between the AvgBalDate and the StartDate. They must be included because the Company and PosNeg parameters are not specified. |
| |
| ==== Required Parameters ==== |
{{section>parameters#userrpt}} | {{section>parameters#userrpt}} |
{{section>parameters#linecode}} | {{section>parameters#linecode}} |
{{section>parameters#avgbaldate}} | {{section>parameters#avgbaldate}} |
==== Optional Parameters ==== | ==== Optional Parameters ==== |
| |
{{section>parameters#company}} | {{section>parameters#company}} |
{{section>parameters#posneg}} | {{section>parameters#posneg}} |
| {{section>parameters#startdate}} |
| |
| |