We are having trouble understanding which rounding algorithim is used in saleslogix so i tried an experiment.

Here is the code:

<p>Dim odd1, even1, even2, odd2
 

 odd2 = 1.255

 odd1 = 61.255

even1 = 2.255

even2 = 6.255

msgbox Round(odd2, 2) & vbCRLF & Round(odd1, 2) & vbCRLF & Round(even1, 2) & vbCRLF & Round(even2, 2)

And here is the result:

1.25

61.26

2.26

6.26

I can't figure out why the 1.255 gets rounded to 1.25 and all the others get rounded to .26.

we are on verson 8.1.

Saleslogix LAN is using VBScript, the round function is within VBScript. You can carry out the same test outside of Saleslogix in a vbs file and you will get the same results of 1.25, 61.26, 2.26 and 6.26.

This is sometimes referred to as Bankers' Rounding.

The following is from Microsoft https://msdn.microsoft.com/en-us/library/se6f2zfx(v=vs.84).aspx which should help explain the results.

"The Round function performs round to even, which is different from round to larger. The return value is the number closest to the value of expression, with the appropriate number of decimal places. If expression is exactly halfway between two possible rounded values, the function returns the possible rounded value whose rightmost digit is an even number. (In a round to larger function, a number that is halfway between two possible rounded values is always rounded to the larger number.)

Round to even is a statistically more accurate rounding algorithm than round to larger."

Thanks for the information.  I guess I'm still a little confused about when is says "the function returns the possible rounded value whose rightmost didgit is an even number"

With the two number 1.255 and 61.255 is the right most didgit the 1?

If so then both of them should have ended with .25, but in my case 1.255 returned 1.25 and 61.255 returned 61.26.

The following has much more on Rounding:

http://www.clivemaxfield.com/diycalculator/popup-m-round.shtml#A5

What you are seeing is rounding in VBScript - sometimes it rounds up and sometimes it rounds down, this is known as Round-Half-Even or Bankers Rounding.