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 function.

This functionality allows data in rows to be added together, divided, multiplied, subtracted and then totaled. These math functions are accessed by clicking on the pull down menu in the row that you wish to add a function to. In this case the data in row 1 will be added to the total.

Below are examples of how this functionality can be used:

__A) Supporting Details__

The below examples adds rows 1 and 2 together and each row provides the timing, description and amount of vehicle insurance expense by vehicle.

__B) Calculations using Exclude Function__

The below example is calculating the Copy Paper Expense taking into account the monthly usage per person per month, the Headcount and cost per case.

1) Enter description assumptions;

2) Enter in the math functions required; and

3) Exclude rows that should not be added to the Grand Total. Please note only the row with the "=" and with the Exclude that is unchecked will be part of the total expense.

__C) Calculations using Lookup and Exclude Functions__

In this example we are using the Lookup function to pull the actual data from FY14. We are using this as a base amount and then increasing it by a 2% cost of living expense (inflationary factor) to result in the FY16 Budget.

1) Use the Lookup functionality to select the data you wish to use;

2) Enter in the math functions required;

3) Exclude rows that should be excluded from the total; and

4) Enter in the cost of living (inflationary) factor that you wish to increase the expense by.

Please note there can be more than one calculation on an entry sheet as only rows that are not excluded will be included in the Total.

# Related Articles

## 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 ...## 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 ...## Expand/Collapse Row View Article

After a report is run, rows can have either a "-" or a "+" symbol to denote an available action to either expand or collapse the account details to reveal or hide the data. On some reports, a Row/Grid Format needs to be selected to activate this ...## Row Format (Grid Formats) Article

Row Formats enable administrators to provide subtotaling rows to enhance the presentation of both data entry and reporting screens in Dynamic Budgets. A single report can be generated and on-the-fly- can be toggled between different Row Formats to ...## Account Details - Row over Row Math Operators Video

click the brackets icon [ ] in the lower right of the video to expand to full screen, hit escape to return to this page