Hi,

When I use the =ACCOUNTGROUP formula in Column B I get incorrect results if I use anything but consolidated departments. This is my formula:
=-ADGET("GLDATA.Y",$B7) and in cell B7 I have:
=ACCOUNTGROUP("FS","SOps","Rev","ISC")

I have set up department lists and want to get reporting on these lists using the Accountgroup formula. Is this possible?


I also noticed that the displayed amount when I use a department list is different that than the amount I get if i drill down on the value.

I am obviously using the wrong formula. Can anyone point me in the right direction?