Round Value in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!
I have a question about rounding. My report show a value, I use format
properity.
Format: #.###;"";""
Decimal Places: 3

In the report, the actually value is ".47152", and it displayed ".472". Now
I don't need round it(to display ".471". Is any way to do that? How can I do
that?
Thank you very much.

Fox
 
Fox,
I'm sure there may be a simpler way, but... (Value = .47152)

Int( [Value] x 1000) / 1000
should do it...
 
Back
Top