GL Financial Reporter - Adagio Accounting

You are not logged in. [Log In] Adagio Home Page » Forums » General Discussion » Technical Support » GL Financial Reporter

Topic Options

#44793 - 03/03/15 07:08 PM GL Financial Reporter
Steve Schwartz Adagio God Registered: 03/10/02 Posts: 4509 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 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: Christa_Meissner

0 registered (), 82 Guests and 0 Spiders online.

Key: Admin, Global Mod, Mod

Forum Stats

1865 Members
5 Forums
14459 Topics
70635 Posts

Max Online: 432 @ 01/20/25 10:17 PM