Just wondering if I can add a dollar amount to a line in financial report with a equation such as - =SUM(ADGET("GLDATA.Y"."6010")) ?

I just want to add an even $24.00. Is it possible?

Thanks, Brenda

Brenda:

The formula structure is the same as in Excel, so you could use:

=ADGET("GLDATA.Y","6010")+ 24

Or, if the amount to be added were in a certain cell, say C5, and were to be used throughout the sheet:

=ADGET("GLDATA.Y","6010") + $C$5

Just make sure that if you are adding to a revenue account, you get the sign correct (Revenues are credits, therefore are multiplied by -1 in the spreadsheet to show as positive numbers.)