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.