Topic Options
#10929 - 01/23/08 04:56 PM ledger 9 financials help
David Dearin Offline
Adagio Scholar

Registered: 06/21/04
Posts: 88
Loc: Heffley Creek, BC
I am having a problem with a couple of formulas in a custom statement that previously worked in version 8 but now gives an error in 9.
I thought to look at the help files to see if the formula had changed or what, but the help screens are all blank,
The help screen from the ledger work fine.
Service pack was applied.
The first formula in question is =IF(F58==0,0,F58/F61) F58 is zero but the cell returns "Error!"
The second formula is =IF(F21,F50/F21,0) both F50 and F21 are zero and the formula returns 281.21%
_________________________
David Dearin

Top
#10930 - 01/23/08 05:05 PM Re: ledger 9 financials help [Re: David Dearin]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Hi David,

Division by zero is undefined (remember your algebra classes?).

SO:
Code:
=IF(F58==0,0,F58/F61)

should probably be:
Code:
=IF(F61==0,0,F58/F61)

Similarly:
Code:
=IF(F21,F50/F21,0)

should probably be:
Code:
=IF(F21<>0,F50/F21,0)

Make sense?
_________________________
Andrew Bates

Top
#10931 - 01/23/08 05:08 PM Re: ledger 9 financials help [Re: Retired_Guy]
David Dearin Offline
Adagio Scholar

Registered: 06/21/04
Posts: 88
Loc: Heffley Creek, BC
Algebra? It graduated in the 60's Andrew. I have trouble remembering a lot of that time period...
LOL
_________________________
David Dearin

Top
#10932 - 01/23/08 05:13 PM Re: ledger 9 financials help [Re: David Dearin]
David Dearin Offline
Adagio Scholar

Registered: 06/21/04
Posts: 88
Loc: Heffley Creek, BC
The first one worked. But the second one...
The symbols <> changed when I hit the enter key to !=
Is that Algebra?
;-)
_________________________
David Dearin

Top
#10933 - 01/23/08 05:17 PM Re: ledger 9 financials help [Re: David Dearin]
David Dearin Offline
Adagio Scholar

Registered: 06/21/04
Posts: 88
Loc: Heffley Creek, BC
On the second one tried F21==0 and that worked.
Because the formulas worked in version 8 I guess Ledger 9 does better math than Ledger 8?
What about the help screen in financial reporter?
_________________________
David Dearin

Top
#10934 - 01/23/08 05:44 PM Re: ledger 9 financials help [Re: David Dearin]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
Dispatching the Help in the current 9.0 Financial Reporter is a known problem and will be addressed in the next service pack.

In the meantime create a shortcut on your desktop for the LedgerFinRep.chm file in ..\Softrak\Ledger

BTW <> and != both mean "not equal" to propeller heads

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 98 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1847 Members
5 Forums
14239 Topics
69728 Posts

Max Online: 359 @ 11/18/19 09:08 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