A user has a ledger with two departments. One has no department code. The other one is department code "1".

When she tries to diaplay a financial report by department, the figures for the blank department include the other one -- ie: identical to the "consilidated" report.

Is there a way around this other than re-creating the whole chart of accounts?

Hi Ralph,

This is something we are aware of - when the Financial Reporter doesn't see a department in the acct-dept key, it sums all departments.

Workaround: Create a formula that finds the difference between all departments and all 'non-blank' departments; the result is the amounts for the blank department. For this client, it's much easier because there is only one other department (1).

=ADGET("gldata.Y","4000-*")-ADGET("gldata.Y","4000-1")

=ADGET("gldata.Y","4000-*")-ADGET("gldata.Y","4000-1:999999")
the above would be for the scenario where there are 2 or more departments and all are numeric.

Hi Ralph (and others reading this),

Another workaround for this scenario which would be potentially easier to use is to include a space after the dash which follows the account.

For example, if you have account 4000 and wish to output the amount for only a 'blank' department, use "4000- " as the account key, with that trailing space character.

Note that this workaround only works for a single account and not a range of accounts (ie "4000:4999- ")