GL Budget Period Totals

This question came in this morning, but for some reason I can't get back to you because the email message bounces back. Here's your question and my answer:

=== QUESTION ===

this is not a tech guy, far from it, yet i know that this should be simple.

GL.Budget

One file gives me the annual amounts found in my budget file and I can see how to get the annual numbers.
then next file will give me the period (12 monthly) amounts that total to the annual amount.

So how do I return the 12 period amounts from the detail file?

Thanks for any help.

=== ANSWER ===

If you are in CS you'll want to use the 'gl.period.budgets.file' as your segment; if you are MAGIC you'll use the 'periods' as your segment. To get the amount for period 1, you'll return budget.ytd. For the other periods, you'll take the budget.ytd and subtract the previous budget.ytd.

If you need help coding this, I can setup a time to WebEx with you.

Great question, thanks for asking,
John