Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Remove decimal places for my crystal reports string variable

I have a string filed in my crystal report with a value of 1,800.667. But I want to display only 1,800 in my report. I am using below formula but that's not working. Any ideas?

totext(tonumber({variable1}),0,"")
like image 578
codematrix Avatar asked Sep 03 '25 04:09

codematrix


1 Answers

Try:

ToText( ToNumber({variable1}), "#" )
like image 130
craig Avatar answered Sep 04 '25 23:09

craig