ryanvb83
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER