Re: Report total not equal to sum of the detail lines

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Report total not equal to sum of the detail lines posted by Mark on January 01, 2005 at 15:09:51:

: : Hi -

: : I'm using FM Personal Version 6.8.344

: : In the Portfolio Value report, I noticed that "total portfolio value" seems to be a bit less than the sum of the individual investment values. I'm displaying all hidden investments, and there are no interpolated prices.

: : I attempted to isolate the problem, and ended up with this:

: : Step 1
: : Close all investments and portfolios
: : Open Investment #1
: : Run Portfolio Value report
: : The one detail line shows 6086.16
: : Total portfolio value correctly shows 6086.16

: : Step 2
: : Close all investments and portfolios
: : Open Investment #2
: : Run Portfolio Value report
: : The one detail line shows 8469.04
: : Total portfolio value correctly shows 8469.04

: : Step 3
: : Close all investments and portfolios
: : Open Investment #1 and #2
: : Run Portfolio Value report
: : Detail line #1 shows 6086.16
: : Detail line #2 shows 8469.04
: : Total portfolio value is now incorrect: 14537.20

: : Correct total value should be 6086.16 + 8469.04 = 14555.20
: : Dicrepancy: 14537.20 - 14555.20 = -18.00

: : Any ideas?

: : Thanks
: : Bill

:
: Hi Bill,

: I don't have any ideas... That doesn't seem right. Do you have any
: transactions or anything that equal $18? Could you email me these
: 2 investment files, so I can try to reproduce this here? Please visit
: our contact form at:

: http://www.fundmanagersoftware.com/contact.html

: and submit a short message, and you will then see our current email address.
: If you can send those 2 investments there, I'll take a look, and see if I
: can't figure out the problem.

: Thanks,
: Mark
: --
: Mark Beiley
: Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP/2003
:

Hi Bill,

Thanks for emailing the investment files. The investment #1 actually shows
a value of 6068.16, not 6086.16. Notice the adjacent 6 and 8 were swapped.
Therefore, the total is shown correctly in Fund Manager as 14,537.20.

Please let me know if that doesn't agree with what you're seeing.

Thanks,
Mark
--
Mark Beiley
Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP/2003

Replies:

• Re: Report total not equal to sum of the detail lines Bill Davison 18:12:26 01/01/05 (0)