SSRS trim trailing 0's from double

Question

I have a calculated field that returns a double "2.000" how can I format this to get rid of unneeded 0's? So that the following occurs:

• When --> Returns
• 2.000 --> 2
• 2.500 --> 2.5
• 2.510 --> 2.51

Answer 1

Cast it into a double like this:

CDbl(value)