I'm creating new statement groups and would like to add departments outside my original departmental ranges. I cannot get the outside department to add into the consolidated totals. Is this even an option?

Hello Jason,

In the Designer, if you open the Department View (View | Departments), are the departments you are trying to add displayed? To create new ranges (spanning departments), shift-click to select the range of departments and right mouse button and select Create Department Range from the pop-up menu. To create a wildcard mask, right mouse button on a signle department.

If this doesn't answer the question, then I'm having trouble picturing the circumstance you are trying to resolve. Can you give an example or two?

They have a department range from 3000 to 3009. They would like to add department 2003 to that range (there are also other departments in the 2000-2009 series).

OK, I understand.

Account ranges can only be contiguous or be selectable by a mask to be included in the department drop-down.

If you want to sum a discontiguous range of accounts, you need to use the =RNGMERGE(s1,s2) function to build your account ranges. s1 will point to a cell containing your account numbers separated by commas. s2 will point to a cell containing your ranges of departments separated by commas. The result of the =RNGMERGE() function should be the second argument to the ADGET() function to get the account balance or net change you're looking form.

To see how these are formed, drag and drop an income statement and tick departmental comparative on the format dialog and chose several discontiguous departments and as for a sum of the departments chosen on the statement.

The deparmental comparative statement in the sample data also uses this function.