My question is: I am trying to create an Income Statement Report that includes all of my departments (60). I am having trouble with the formulas I am writting.

How do I do this in a cell? Ex. Fund+income+expense for a MTD or a YTD total. Row #1...#2 with a different department.

And, report in one page all 60 departments using One row for each department.

Hi Ana,

The basic syntax for a formula in the Financial Reporter is:

=ADGET("gldata.field","Acct-Dept")
where field is the field information
Acct is the single or range of accounts
Dept is the single or range of departments

You do not have to 'hard-code' the account or department into the formula, but instead can use 'cell references' to get that information, exactly like you would in Excel.

Because you want one row for each department, you can enter the department code in column A for each of the 60 rows, then have all the information about that department appear in the respective rows.

For example, say you want the YTD amount for the range of accounts 1000 to 3999, specifically for department 100, to appear in row 10. The field code for YTD is 'Y' - you can see this in the View Account Data window.

Thus in cell A10, you would type '100 (including the apostrophe in front to identify this as a string field). In column B, the formula would be =ADGET("gldata.Y","1000:3999-"&$A10)

The formula is reading the field Y (or YTD info) for the range of accounts 1000 to 3999 and the department found in cell A10. The ampersand '&' is necessary, and is the standard symbol used for adding two text fields together. The dollar sign '$' is not required, but very useful if you wish to Copy/Paste your formulas. Having the $ will allow the reference to the Department code in Column A to update approriately for each row.

Regards,