Both sides previous revision Previous revision | |
gl_excel:lineaverageround [2010/06/21 15:47 UTC] – removed reference to unavailable Company parameter mwolfe | gl_excel:lineaverageround [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 |
---|
* then the AvgBal User Report Adjustment is applied | * then the AvgBal User Report Adjustment is applied |
| |
%InlineCode{LineAverageRound(UserRpt, LineCode, AvgBalDate, //PosNeg//, //StartDate//)}% | **LineAverageRound(UserRpt, LineCode, AvgBalDate, //PosNeg//, //StartDate//)** |
| |
%fineprint{*NOTE: The Company parameter is not supported for this function because it would require User Report Adjustments to be made on a company by company basis, which would add too much complexity to the process.}% | %fineprint{*NOTE: The Company parameter is not supported for this function because it would require User Report Adjustments to be made on a company by company basis, which would add too much complexity to the process.}% |
| |
==== Example Usage ==== | ==== Example Usage ==== |
* %InlineCode{=LineAverageRound("BALCON", "A01", "7/31/2009")}% Returns the daily average balance in thousands for line A01 of the BALCON user report during the month of July, 2009. | * **=LineAverageRound("BALCON", "A01", "7/31/2009")** Returns the daily average balance in thousands for line A01 of the BALCON user report during the month of July, 2009. |
* %InlineCode{=LineAverageRound("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. | * **=LineAverageRound("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{=LineAverageRound("BALCON", "A01", "6/30/2009", , "1/1/2009")}% Returns the daily average balance in thousands for line A01 of the BALCON user report during the first two quarters of 2009. | * **=LineAverageRound("BALCON", "A01", "6/30/2009", , "1/1/2009")** Returns the daily average balance in thousands for line A01 of the BALCON user report during the first two quarters of 2009. |
* Note the extra comma between the AvgBalDate and the StartDate. It must be included because the PosNeg parameter is not specified. | * Note the extra comma between the AvgBalDate and the StartDate. It must be included because the PosNeg parameter is not specified. |
| |