3
votes

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,"")
2
not working any error?Siva

2 Answers

11
votes

Try:

ToText( ToNumber({variable1}), "#" )
-2
votes
IF int({FieldName})<>{FieldName}then
2
else 
0