I have multiple stations that I require Bal Sheets, Income Stmts - separately and rolled up. The ability to use 'masks' has enabled me to build a generic bal sheet, but my problem comes when attempting the Income Statement.

Sales/COS - no problem. They are accounts that end in 000, and my mask brings only that station (I think it is utilizing a 'department' for the station).

I have a number of accounts from 6000 thru to 6999, and I need sub-ttls for each department(100, 150, 200, 300, 350 etc), which is the last 3 digits of my 6-digit department (first 3 is the station.

I have tried 6000:6999-???100 - which brings every station ending in 100. If I have picked a mask - I just want one station, and that department.

I have tried many things and was just wondering if there is another wild card, or if I should mask as something other than a department?

I would love to get one template that interchanged the additional lines I want saved, and how the titles are into the middle. And all I would have to do is change the station for each one - and still have a rollup.

As it is I have capable reports for each station - but every time someone wants the liabilities as whole numbers, or get rid of the blah blah - I have to re-do all 13 stations.

Any help would be appreciated. I have watched the 2 webinars.

thanks

Hi abc,

There is only a single drop-down field from which to pick a department - the full 6 characters or with a wild card mask. There are not 2 independant drop-down fields from which you can pick the first 3 digits (the station) and the last 3 digits (the department). I presume that this is what you were looking for, or something similar.

The purpose of wildcards/masks is to group multiple departments that match a pattern. In the example you cited, the selected 6-character department codes should be all those where the last 3 digits are '100', which in your case would be every station. If this is what is happening for you, then this is the expected behaviour.

If you pick the full 6 character code from the drop down - say '123100' - then you would get station 123 and department 100 for accounts 6000:6999.
---
Perhaps you could completely ignore the department drop-down field. Instead hard-code the account key that belongs in column B cells with the mask. You would do one row for each of your 3-digit departments, such as 6000:6999-???100. This would affect how Expand generates accounts and departments, and may not be what you are looking for.

You could even use a formula to build the account key for a specific station. For example, reserve a cell such as B3 to type in the 3-digit station code.
Then for an account key in some cell in column B, it could look like:
="6000:6999-" & $B$3 & "100"
This would take whatever station code was in cell B3 and insert it into the account key.

You may need to post a more specific example of what layout you are expecting (and what you mean by 'rollup'). You may also want to get your Adagio consultant involved.

This is what we ended up doing.
Cell B3 is where the station will be entered example '120
The forumla ="6000:6999-"&$B$3&"100" is used.
The "100" is changed for each range to represent the "dept"
This is exactly the outcome desired.
It shows accounts for the station sub totaled by department.