CODEWITHSUNDEEP
reporting-servicesssrs-2008trimssrs-2008-r2
ism
ism

Reputation: 298

SSRS trim trailing 0's from double

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:

Upvotes: 1

Views: 991

Answers (2)

ism
ism

Reputation: 298

Cast it into a double like this:

CDbl(value)

Upvotes: 2

Tak
Tak

Reputation: 1562

In the Text box properties >> Format enter

#.####

This will display as you require.

Upvotes: 0

Related Questions