Rounding a number

Hi,

I need to round a number in a table to either 2 or 4 decimals:

=((Sum(Fields!Total.Value) -Sum( Fields!Total_used.Value))*100)/(Sum(Fields!Total.Value)) & " %"

This results in a number like 91,1243656438345%

I would like it to be rounded to 91,1244% or 91,12%

Is there any builtin round-function, that does not just turn the number into an integer?

Thanks for your help

You should be able to do this using the Format function

=format(Sum(Fields!value.Value),"#,###.0000%")

or

=format(Sum(Fields!value.Value),"#,###.00%")

|||

Thanx - I wasn't familiar with that function. It works perfectly :-)

-- Heidi --

|||You might just need to change your format settings to conform to your use of a comma (,) as opposed to a UK full stop (.) for the decimal separator...|||Yup.... but my reports are running in various contries, so I already use different formatting depending on the users language settings. Not a problem :-)|||I've discovered that the use of comma or dot as seperator is automatic depending og language settings... So in this case I don't need to do anything... finally something is simple and straightforward ;-)