February 10, 2012 at 7:37 am
This is a simple one, but I'm having a difficult time figuring it out.
So I have the number 5.78 in one of my columns. I want to format the number so it looks like 6.00. This format (#.'00') gets me to 600. This format (#.".""00") gets me 6.00 but I know it's not right. Why doesn't the decimal show up in the first one??? It's driving me NUTS haha. Any help would be MUCH appreciated.
Thanks!
February 10, 2012 at 8:14 am
Hi
Just a thought but can't you do this in your dataset using the CEILING function rather than in SSRS?
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 10, 2012 at 8:35 am
Hmmm, I'm not exactly sure what you're talking about. How do I do this?
February 10, 2012 at 8:37 am
Ooooh, you mean code it in?? If so, I've never used the CEILING function but I'm sure I can figure it out. Thanks for the tip!
Mike
February 10, 2012 at 8:39 am
Heres a link to get you started
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply