Showing posts with label thousand. Show all posts
Showing posts with label thousand. Show all posts

Wednesday, March 7, 2012

Rounding to the nearest thousand

Hi

Which parameter value for the Round function do I need to pass to get it to round to the nearest thousand ?

Thanks,
Neil

Hello Neil,

Try this:

=Round(Fields!Field1.Value, 3)

Hope this helps.

Jarret

|||

Sorry, I mis-read your question. I thought it said thousandth.

This should do what you want:

=cInt(Fields!Field1.Value / 1000) * 1000

Jarret

|||

For formatting it is

#,###,.

|||Thanks Jarret, Just what I needed..

Thanks!!
|||Thanks Ewild!

You read my mind!! Also just what I needed Smile