views:

630

answers:

1

Hello,

I'm using Report Viewer Control (rdlc) to generate reports. One of my columns have the value

=AVG(Fields!Reading.Value, "CellReading_Reading")

I'm getting the value with 10 or more decimal places. But i want to round it off to 3 decimal places. What is the expression for doing this?

Thank you. NLV

+2  A: 
FormatNumber(AVG(Fields!Reading.Value, "CellReading_Reading"),3)
cdonner
Thank you. Worked like a charm!
NLV
What if i want a string 5500 as 5,500?
NLV
Okie, i found the answer. Need to set the group digits to "true" in the same FormatNumber().
NLV

related questions