Communications
club_cafe
HelpRegister
Rounding Calculations
  I have a very quick question regarding the process bivio
  uses to round off numbers. Our club has two members who
  joined on the same day, paid the same amount, and
  purchased the same number of units. When I looked at
  today's Member Status report there is a difference of .01
  between the two members.
  When a member asks me "why" there is any difference, when
  everything should be equal, I want to have an answer.
  Obviously, a .01 difference is not a major problem but it
  begs the question as to why there is a difference. Simply
  saying it's a "rounding issue" will not explain how, or
  why, bivio rounded one value up while not also rounding
  the other value to the next higher number. Shouldn't the
  rounding process be standard in such instances?
  Each member has .283392 units. Unit Value is $173.169759.
  Units X's Unit Value equals $49.074921. One member's
  value is $49.08 and the other's unit value is $49.07.
  Why?
  My goal is to learn as much as I can about the way bivio
  performs calculations...an explanation for the one cent
  difference, while not a significant amount, will provide
  insight into the way the bivio software thinks!
Thank you.

Bob Hooper
New Pueblo Investment Club
Tucson, AZ
Robert Hooper wrote:
> Each member has .283392 units. Unit Value is $173.169759.
> Units X's Unit Value equals $49.074921. One member's
> value is $49.08 and the other's unit value is $49.07.
 
If two members have an unrounded value of $49.074921, then the
unrounded total would be $98.149842. For the reports, we round the
total to the penny, or $98.15.
 
So for display purposes, we could show:
 
Member A, 49.07
Member B, 49.07
Total, 98.15
 
But this doesn't add up correctly, so instead we distribute the
floating penny among the members:
 
Member A, 49.08
Member B, 49.07
Total, 98.15
 
Paul Moeller
bivio, Inc.
Thanks for the very prompt reply, Paul! Very impressive,
indeed!

So, if I understand you correctly, the only time these two
members will have an equal value is when the rounded total
equals an even number of cents. Is that correct?

Thank you.

Bob Hooper
New Pueblo Investment Club
Tucson, AZ

Paul Moeller wrote:
> Robert Hooper wrote:
> > Each member has .283392 units. Unit Value is $173.169759.
> > Units X's Unit Value equals $49.074921. One member's
> > value is $49.08 and the other's unit value is $49.07.
>
> If two members have an unrounded value of $49.074921, then the
> unrounded total would be $98.149842. For the reports, we round the
> total to the penny, or $98.15.
>
> So for display purposes, we could show:
>
> Member A, 49.07
> Member B, 49.07
> Total, 98.15
>
> But this doesn't add up correctly, so instead we distribute the
> floating penny among the members:
>
> Member A, 49.08
> Member B, 49.07
> Total, 98.15
>
> Paul Moeller
> bivio, Inc.
Robert Hooper writes:
> So, if I understand you correctly, the only time these two
> members will have an equal value is when the rounded total
> equals an even number of cents. Is that correct?

Yes.

Rob