Rounding Calculations
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 |
|