Both sides previous revision Previous revision Next revision | Previous revision |
gl_excel:avgbal [2010/06/18 14:37 UTC] – added Example Usage mwolfe | gl_excel:avgbal [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 |
---|
This is the average balance function. It returns the daily average balance of a GL account for a given month (or span of months). | This is the average balance function. It returns the daily average balance of a GL account for a given month (or span of months). |
| |
%InlineCode{AvgBal(AcctNum, AvgBalDate, //PosNeg//, //StartDate//)}% | **AvgBal(AcctNum, AvgBalDate, //PosNeg//, //StartDate//)** |
==== Example Usage ==== | ==== Example Usage ==== |
* %InlineCode{=AvgBal("1010-000", "7/31/2009")}% Returns the daily average balance for account 1010-000 during the month of July, 2009. | * **=AvgBal("1010-000", "7/31/2009")** Returns the daily average balance for account 1010-000 during the month of July, 2009. |
* %InlineCode{=AvgBal("1010-000", "6/30/2009", ,"1/1/2009")}% Returns the daily average balance for account 1010-000 during the first two quarters of 2009. | * **=AvgBal("1010-000", "6/30/2009", ,"1/1/2009")** Returns the daily average balance for account 1010-000 during the first two quarters of 2009. |
* Note the extra comma between the AvgBalDate and the StartDate. That must be included because the PosNeg parameter is not specified. | * Note the extra comma between the AvgBalDate and the StartDate. That must be included because the PosNeg parameter is not specified. |
* %InlineCode{=AvgBal("1010-000", "3/17/2009", "C", "10/22/2008")}% Returns 'Debit Balance' because the daily average balance for account 1010-000 for the last quarter of 2008 and first quarter of 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. | * **=AvgBal("1010-000", "3/17/2009", "C", "10/22/2008")** Returns 'Debit Balance' because the daily average balance for account 1010-000 for the last quarter of 2008 and first quarter of 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. |
| |
==== Required Paramaters ==== | ==== Required Parameters ==== |
{{section>parameters#acctnum}} | {{section>parameters#acctnum}} |
{{section>parameters#avgbaldate}} | {{section>parameters#avgbaldate}} |