Given the department codes you have set up a departmental mask will not help you.

Instead, take a look at the Adagio =function called RngMerge.

It will allow you to consolidate a range of non contiguous accounts (and departments).

You can find a description of the function in the Adagio Help under Adagio =Functions

Departmental masks are designed to group departments with similar structure (such as all that end with '10'). They use the ? or * wildcards; in the example above the mask would be ????10 or *10.

If you want to sum specific non-consecutive departments together, there are 2 way of doing this.

1) Put departments 1,3 and 9 in their own column and use a 4th column to simply add them together like a typical spreadsheet. ie =D6+E6+F6

2) There is a function called RngMerge that was created with this scenario in mind. Full description of this is in the Help file for the Financial Reporter, but here's something to get you started.

- All your accounts are coded in one cell (say A8), with each followed by a dash and separated by commas:
eg "4000:4499-, 4800-, 4900:4999-"
- All your departments are coded in a different cell (say F5), also separated by commas:
eg "1,3,9"
- Your formula uses RngMerge:
eg =ADGET("gldata.Y",RngMerge(A8,F5))

It's often easiest to put the accounts in column A and the departments in a row across the top.
===
Departmental masks can be deleted by clicking on the mask field in the Department View with the right mouse button and selecting "Delete Departmental Mask" from the pop-up menu.

To delete your departmental masks you will need to do the following.

Use Maintenance, Maintain Financial Reports, View Departments.

Then Right click in the Departments window. If masks exist you will then have the options to Edit or Delete the departmental mask. If no masks exist you can use the Create.

If you do not have the option to Delete Departmental Mask, you can also edit the data file that stores the masks to remove the one that you do not need.

The data file is GLDTREE.{ext}. It is a simple text file. Please make sure that no one is in the Financial Reporter before you edit this file.