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.