Hi all,

I am trying to create a report which shows the remaining budget for the fiscal year. Is this included in the 'Account Data' Tree? I have been trying every single option to do it and it won't show.

What will be the formula to be entered on the worksheet if I want to calculate the remaining budget of the fiscal year?

Are you looking for the Budget for the Year ("B") minus the YTD Budget ("BY") or the Budget for the year ("B") minus the YTD expenses or revenue ("Y"). In either case you'd need to do the math with two =GETAMT() formulas.

This is really a technical support question, so I will move the thread into that Forum.

Hi Andrew,

I want to show the amount of remaining budget = [total budget - total actual expense to date]

The best way to find the codes you need is to play around with the reports in the sample data. You will find that modifying an existing report from the sample data is generally much simpler than trying to figure out all the pieces on your own.

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.

GL!BudgetForecast2 springs to mind.