Topic Options
#44793 - 03/03/15 07:08 PM GL Financial Reporter
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4556
Loc: Wynnewood, PA
Is there an easy way to print the sum of the budget figures across years - for example the budgets for an account/department for the last 10 years?

I can think of a roundabout way, but maybe I'm missing something.

Thanks

Steve

Top
#44794 - 03/03/15 09:01 PM Re: GL Financial Reporter [Re: Steve Schwartz]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Assuming the account range is in cell B10:
Code:

=GLAMT("{9}B",B10)+GLAMT("{8}B",B10)+GLAMT("{7}B",B10)+GLAMT("{6}B",B10)+GLAMT("{5}B",B10)+GLAMT("{4}B",B10)+GLAMT("{3}B",B10)+GLAMT("{2}B",B10)+GLAMT("{1}B",B10)+GLAMT("B",B10)



_________________________
Andrew Bates

Top


Moderator:  Softrak Support 
Who's Online
1 registered (RSabatini), 91 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1870 Members
5 Forums
14611 Topics
71330 Posts

Max Online: 1408 @ 12/09/25 01:48 AM
April
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