This question was asked via e-mail:

What is the formula for present an amount that is last year to date for the current period. I know you can do last year current period, last year period x, last year quarter to date but what about last year to date as of this period. For example, need current period, current period last year, year to date, year to date last year.

Current period = ADGET("gldata.M",accountrange)
Current period last year = ADGET("gladat.LYM",accountrange)
Year to date = ADGET("gldata.Y",accountrange)
Last year YTD = ADGET("gldata.LYY",accountrange)

A complete list of the available codes can be printed by selecting File | Send to sheet | Account data. View | Account data displays the available choices in a tree view for reference. The codes shown always follow "gldata." in the ADGET formula.

In the Sample data, the specification "GL!SuperSpec.SAM" contains the numeric result and fiscal period range for every formula available in the financial reporter.