Reporting Services hide decimal point

I have a calculation in a group header that returns a number with 2 decimal places.  I want to simply remove the decimal from the value of that box.  I'm using this report as input into a mainframe and it does not accept decimal points.  For example, if the value of my box is currently "100.00", I need it to show "10000".  I've tried replace() and that worked but it truncated all zeroes after where the decimal point used to be.  For numbers like "19.99" it works fine because it returns "1999".  But, for numbers like "19.90", it returns "199".  Any ideas?
ryanvb83Asked:
Who is Participating?
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
Multiply your number by 100 first.  Then either use your replace() trick or see if you can format the field with F0 for fixed no decimals.
0
 
ryanvb83Author Commented:
It's been a really long day.  I figured it was something simple that I was overlooking.  Multiplying by 100 fixed it...obviously.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.