| |
gl_excel:lineround [2010/06/21 16:30 UTC] – created mwolfe | gl_excel:lineround [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 |
---|
* then the Actual User Report Adjustment is applied | * then the Actual User Report Adjustment is applied |
| |
%InlineCode{LineRound(UserRpt, LineCode, BalanceDate, //PosNeg//)}% | **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.}% | %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{=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", "A01", "7/31/2009")** Returns the adjusted balance in thousands for line A01 of the BALCON user report as of July 31, 2009. |
* %InlineCode{=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", "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. |
* %InlineCode{=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. | * **=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 ==== | ==== Required Parameters ==== |