ansaurus

Question

SQL Server Reporting Services Round() function

Answer 1

+2 A:

It sounds like round to even, also known as Banker's rounding.

The other option is "away from zero", which is what you want:

Round(4.5, 0, MidpointRounding.AwayFromZero)

Mark Byers 2010-02-04 19:41:10

Updated answer - just realised that AwayFromZero is what you want.

Mark Byers 2010-02-04 20:20:37

Thanks, I will try this. I was puzzeled because I read the documentation and when I tried MidpointRounding.AwayFromZero the code was underlined as wrong. Anyway, I will give it a try...

Marcos Buarque 2010-02-04 21:46:25

Awayfromzero worked for me, but the red-underlined was still there. Where do I place the import System? Thank you for the help.

Marcos Buarque 2010-02-05 03:12:08

using System, sorry... or just be explicit: System.MidpointRounding.AwayFromZero

Mark Byers 2010-02-05 06:27:58

Answer 2

+1 A:

Use the MidpointRounding.AwayFromZero option:

Round([calculated number], [num decimal places], MidpointRounding.AwayFromZero)

slugster 2010-02-04 20:22:20

Thanks, I will try this and let you know.

Marcos Buarque 2010-02-04 21:45:14

ansaurus

tags:

views:

answers:

SQL Server Reporting Services Round() function

related questions