Hello Ryan,

There is a "better" way to accomplish what you need than referencing another sheet (for which you use the =QUERYSHEET() function in the financial reporter).

Just as the financial reporter to calculate the .BALance for the range of account numbers on the income statement. Say that all your P&L acccounts fall in the range of account number 4000 to 6999. You'd then use the formula:
Code:
=ADGET("gldata.BAL","4000:6999")

to get the balance calculated over all the P&L accounts with the result returned in a single cell.

Make sense?
_________________________
Andrew Bates