====== LineRound ====== This function returns the [[LineBalance]] in thousands. Its usage and parameters are the same as the LineBalance function, with the exception of the Company parameter*. The LineBalance function is called then the following calculations are performed on the result: * the value returned is rounded to the nearest thousand * then divided by one thousand * then the Actual User Report Adjustment is applied **LineRound(UserRpt, LineCode, BalanceDate, //PosNeg//)** %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 ==== * **=LineRound("BALCON", "A01", "7/31/2009")** Returns the adjusted balance in thousands for line A01 of the BALCON user report as of July 31, 2009. * **=LineRound("BALCON", "M02", "12/31/2009 8:00PM")** Returns the adjusted balance in thousands for line M02 of the BALCON user report following the 2009 year end closeout. * **=LineRound("BALCON", "A01", "3/17/2009", "C")** Returns 'Debit Balance' because the adjusted balance in thousands for line A01 of the BALCON user report on March 17, 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#userrpt}} {{section>parameters#linecode}} {{section>parameters#balancedate}} ==== Optional Parameters ==== {{section>parameters#posneg}}