Topic Options
#4056 - 05/26/04 03:18 PM Adagio FX - Financial Reporter codes.
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
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.


Top
#4057 - 05/26/04 03:21 PM Re: Adagio FX - Financial Reporter codes.
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
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.


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 77 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14474 Topics
70689 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31