Hi Tim,
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.