This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revisionBoth sides next revision |
gl_excel:avgbal [2010/06/18 14:37 UTC] – added Example Usage mwolfe | gl_excel:avgbal [2015/10/08 20:10 UTC] – fix typo mike |
---|
* %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. | * %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 Paramaters ==== | ==== Required Parameters ==== |
{{section>parameters#acctnum}} | {{section>parameters#acctnum}} |
{{section>parameters#avgbaldate}} | {{section>parameters#avgbaldate}} |