Exclude Row Function Article
This standard functionality is available in a number of screens including Basic Budget Entry/Account Details and Import Budget Assumptions.
By checking the "Exclude" box, the data on that row is not included in calculations for the Total.
This functionality can be used to include additional information to support calculations as well as remark lines.
In the below example, row 2 is excluded. Please note that the total for the Account Number is $150. If row 2 was not excluded the total would be $250 ($150 + $100).
Related Articles
Row to Row Calculations Article
This standard functionality is available on a number of screens including Basic Budget Entry/Account Details and Import Budget Assumptions. Please note that this functionality can be used in conjunction with the Exclude Row Function and the ...Lookup Article
This standard functionality provides the ability to access data that is within the system and then copy the data to the appropriate Assumption Grid. The general process will be discussed first followed by a review of the available data. The Lookup ...Manage Global Variables Article
Global Variables are setup to store statistical (nonfinancial and non-system based financial) data and are accessed through Lookup. Please see the related article How Can I Use Global Variables? Print, Export to Excel, Print to PDF, Auto-size ...Define Row Formats Article
This tool is used to total and subtotal data into user defined formats. After changes are made, please Save. Please note that Expand/Reduce Column Width functionality is available. A) To Add a New Format We will first review the process and then ...Custom Reports Article
Tutorial Link Purpose: To create custom reports which can include actuals, budgets, variances and comments for an organization. The report is structured to the user's needs. Reports with a customized Column Format as defined in Define Custom ...