Name

Weight

Arnold_1

0.317515 kg

Arnold_2

0.317548 kg

Arnold_3

0.317562 kg

Arnold_4

0.318 kg

Arnold_5

0.3 kg

Arnold_6

0.3401987 kg

Name

Weight

John_1

0.7 lbsmass

John_2

0.67 lbsmass

John_3

0.73 lbsmass

John_4

0.69 lbsmass

John_5

0.71 lbsmass

John_6

0.70 lbsmass

Name

Weight Entered by Arnold

Display Weight for John

Weight Saved in Database

Arnold_1

0.317515 kg

0.700001 lbsmass

0.317515 kg

Arnold_2

0.317548 kg

0.7000003 lbsmass

0.317548 kg

Arnold_3

0.317562 kg

0.7000034 lbsmass

0.317562 kg

Arnold_4

0.318 kg

0.701 lbsmass

0.318 kg

Arnold_5

0.3 kg

0.7 lbsmass

0.3 kg

Arnold_6

0.3401987 kg

0.7500097 lbsmass

0.3401987 kg

Name

Weight Entered by John

Display Weight for Arnold

Weight Saved in Database

John_1

0.7 lbsmass

0.3 kg

0.317514659 kg

John_2

0.67 lbsmass

0.30 kg

0.3039068879 kg

John_3

0.73 lbsmass

0.33 kg

0.3311224301 kg

John_4

0.69 lbsmass

0.31 kg

0.3129787353 kg

John_5

0.71 lbsmass

0.32 kg

0.3220505827 kg

John_6

0.70 lbsmass

0.32 kg

0.317514659 kg


When rounding converted unit values to their display values, traditional rounding rules apply. For example. 0.25 rounds to 0.3. This is different than rounding in search ranges.

This difference is important. If the base unit was pounds and no conversion was taking place, John could expect the search to return a much smaller range of 0.795 to 0.705 pounds. 
Name  Display Weight  
John_1  0.7 lbsmass  
John_5  0.71 lbsmass
 
John_6  0.70 lbsmass  
Arnold_1  0.700001 lbsmass  
Arnold_2  0.7000003 lbsmass  
Arnold_3  0.7000034 lbsmass  
Arnold_4  0.701 lbsmass 
Name  Display Weight 
John_1  0.3 kg 
John_6  0.32 kg 
Name  Display Weight for Arnold  Weight Saved in Database 
John_1  0.3 kg  0.317514659 kg 
John_2  0.30 kg  0.3039068879 kg 
John_3  0.33 kg  0.3311224301 kg 
John_4  0.31 kg  0.3129787353 kg 
John_5  0.32 kg  0.3220505827 kg 
John_6  0.32 kg  0.317514659 kg 