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 17:05:53:

: : : 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
:

Mark,

You're right - it was a typo on my end. Sorry to bother you with it.

Bill

Replies: