Thanks Andrew, still one issue on this one however, Adagio is still pulling the subtotals of groups of accounts from the consolidated statement through to the departmental statement.

The individual lines are correct in the departmentalized statement, just have wonky subtotals.

The formulas are chaged, the statement was looking correct, but then it refreshes and Adagio seems to be picking it up the incorrect information.

I am going to send you a copy of this to have a look at when you get a chance as it is a rush situation and we don't want to spin our wheels on this one.

Thanks Andrew