The easiest way to see that you are getting the correct results would be to set up three columns:

The first two uses the =GETAMT() expression to read the Adagio database. The third is simple math to subtract column 2 from column 1.

1. Budget for the year "B"
2. YTD actuals "Y"
3. Column 1 less column 2 (B-Y) = budget remaining

You can then either hide column 1 and 2 or once you are comfortable that you have the correct answer or you can create just one column with a formula that replicates column 1 minus column 2.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com