LineBudgetRound

This function returns the LineBudget in thousands. Its usage and parameters are the same as the LineBudget function. The LineBudget 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 Budget User Report Adjustment is applied

%InlineCode{LineBudgetRound(UserRpt, LineCode, BudgetDate, Company)}%

Example Usage

%InlineCode{=LineBudgetRound("BALCON", "A01", "7/31/2009")}% Returns the budget in thousands for line A01 of the BALCON user report for the month of July 2009.

%InlineCode{=LineBudgetRound("BALCON", "A01", "3/17/2009", "Cit")}% Returns the budget in thousands for the Citizens Savings Bank accounts in line A01 of the BALCON user report for the month of March 2009 (ie, it excludes all of the service company accounts). See below for more information about the Company parameter.

Required Parameters

UserRpt

The name of the user report (not its description)

"BALCON"
"INCST2"

%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%

LineCode

The 3-digit user report line item code.

"A01"
"C15"

%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%

BudgetDate

The date that represents the month and year used to retrieve the budget numbers

"3/31/2009" Returns the budget for March 2009
"3/1/2009" Returns the budget for March 2009
"3/17/2009" Returns the budget for March 2009

%fineprint{Used in: Budget, FedRptBudget, LineBudget, LineBudgetRound}%

Optional Parameters

Company

The company suffix code used to restrict user report numbers to a single company. To include all companies, either 1) do not enter anything for this parameter or 2) use the abbreviation "Con" (for Consolidated). To include only the default Citizens company, use either 1) double quotes with nothing inside: "" or 2) the abbreviation "Cit" (for Citizens).

Consolidated
"Con" Consolidated
"" Citizens Savings Bank
"Cit" Citizens Savings Bank
"CSA" CSA Services, LLC
"CSB" CSB Services, Inc.

%fineprint{Used in: FedRptAvgBal, FedRptBalance, FedRptBudget, LineAverage, LineBalance, LineBudget}%