Round () function of SQL Server Reporting Services

Question

there is some bizarre thing that happens to my report created in SQL Server Reporting Services, and I hope I'm not too stupid. I use the Round function to get integers. Sometimes 4.5 will be round to 4, and 5.5 will be rounded to 6. Is it because of the rounding method? I use this:

Round(Fields!GroupAverageAssessment.Value,0)

How can I do regular rounding (from 4.5 to 5, from 3.5 to 4, from 6.5 to 7, etc.)

thanks

Answer 1

Sounds like round to even , also known as Banker Rounding.

Another option is "from scratch", what you need:

Round(4.5, 0, MidpointRounding.AwayFromZero)

Answer 2

MidpointRounding.AwayFromZero:

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