====== LineAverage ====== This is the user report line average balance function. It returns the daily average balance for a user report line during a given month. **LineAverage(UserRpt, LineCode, AvgBalDate, //Company//, //PosNeg//, //StartDate//)** ==== Example Usage ==== * **=LineAverage("BALCON", "A01", "7/31/2009")** Returns the daily average balance for line A01 of the BALCON user report during the month of July, 2009. * **=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. * **=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. * 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#linecode}} {{section>parameters#avgbaldate}} ==== Optional Parameters ==== {{section>parameters#company}} {{section>parameters#posneg}} {{section>parameters#startdate}}