Differences

This shows you the differences between two versions of the page.

--- gl_excel:avgbal [2010/06/17 18:35 UTC] – mwolfe
+++ gl_excel:avgbal [2015/10/08 20:10 UTC] – fix typo mike
@@ Line 1: / Line 1: @@
-===== AvgBal =====
+====== AvgBal ======
 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//)}%
+==== Example Usage ====
+  * %InlineCode{=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.
+    * 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.
 ==== Required Parameters ====
 {{section>parameters#acctnum}}
 {{section>parameters#avgbaldate}}
-----
 ==== Optional Parameters ====
 {{section>parameters#posneg}}
 {{section>parameters#startdate}}