July 17, 2018 at 5:35 am
I'm using Report Builder 3.0 to try and create a bank report.
One of the fields I have to include in the report is the check amount. But the bank requires the amount to have two implied decimal places. I used the REPLACE(CheckAmt.Value,".","") to replace the decimals with nothing. But when I do this, Report Builder adds an extra zero to the end. So what I’d like to do now is use some soft of LEFT() function or something to get everything but the last trailing zero.
Does that path make sense? or should I go about this a different way?
July 17, 2018 at 6:33 am
machzy - Tuesday, July 17, 2018 5:35 AMI'm using Report Builder 3.0 to try and create a bank report.
One of the fields I have to include in the report is the check amount. But the bank requires the amount to have two implied decimal places. I used the REPLACE(CheckAmt.Value,".","") to replace the decimals with nothing. But when I do this, Report Builder adds an extra zero to the end. So what I’d like to do now is use some soft of LEFT() function or something to get everything but the last trailing zero.
Does that path make sense? or should I go about this a different way?
Have you tried multiplying by 100, truncating and converting to integer?
July 17, 2018 at 8:23 am
Luis Cazares - Tuesday, July 17, 2018 6:33 AMmachzy - Tuesday, July 17, 2018 5:35 AMI'm using Report Builder 3.0 to try and create a bank report.
One of the fields I have to include in the report is the check amount. But the bank requires the amount to have two implied decimal places. I used the REPLACE(CheckAmt.Value,".","") to replace the decimals with nothing. But when I do this, Report Builder adds an extra zero to the end. So what I’d like to do now is use some soft of LEFT() function or something to get everything but the last trailing zero.
Does that path make sense? or should I go about this a different way?
Have you tried multiplying by 100, truncating and converting to integer?
You're so smart! That worked! Thanks so much!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy