Topic Options
#16047 - 02/19/09 08:51 AM Financial Reporter-Adding a checksum not working
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
We are adding a formula to an existing statement.
The formula is a very basic SUM formula.
=SUM(D40..D109)
But when we switch to any other period or perform another calculation, the formula re-writes itself to something like =SUM(D110..D179).

The client is runing Ledger Version 9.0a (080122).

How do we keep the formula from rewriting itself? (Why is this happening?)

Samuel
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#16049 - 02/19/09 10:15 AM Re: Financial Reporter-Adding a checksum not working [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Are there any ".Range" commands above the =SUM()? These may be adding rows.

Use the SUM button on the toolbar to explicitly add the cell together you want. Make sure the sheet is collapsed when entering the formula.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
4 registered (Arun, sathish, Softrak Support, 1 invisible), 91 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14460 Topics
70636 Posts

Max Online: 432 @ 01/20/25 10:17 PM
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