Hello Ken A.,

Is it meant to look like this?

code:

              Actual YTD  Bud YTD Variance
Revenue
     Dept 1      100        90       10
     Dept 2      350       400      (50)
     Dept 3      150       125       25
Total Revenue    600       615      (15)
Expenses
     Dept 1      90         85        5      
     Dept 2      300       340      (40)  
     Dept 3      100       110      (10)        
Total Expense    490       535      (45)
Surplus(Deficit) 110        80       30

A couple of questions:

Do you want a row for each department?

When you say "basically", do you mean that there are some expense accounts in amongst the revenue accounts, and you don't want to have to itemize them in the formula?

Normally, turn on the "SmartSheet", place the account range in column A, and the department number in column B. Then use the formulas:

code:

=ADGET("GLDEPT.DESC",Bn) to get the department name
=ADGET("GLDATA.Y",RangeMrg(An,Bn) (make sure that the account number includes the separating "-")

(Everything's possible in Adagio's Financial Reporter!)

Oh yes! If you turn on the SmartSHeet, you can "drag and drop" from your chart of accounts in the account ranges in column A.