Formatting a number in a formula in Crystal Reports

I have this formula:
Round({Purchorder.NBR-LINES}) & "/" &  Round({Purchorder.CLOSED-LINES})

The results of this formula display the data:
Closed/Total
1.00/1.00

I am trying to NOT display the .00.  I have tried many versions of the Round and RoundUp function, such as, RoundUp({Purchorder.NBR-LINES}), 2) and the .00 still displays on the report.  Suggestions on how NOT to display the .00.
garyjgsAsked:
Who is Participating?
 
peter57rCommented:
Assuming you must round, then to remove the zero do..
totext(Round({Purchorder.NBR-LINES}) ,0,"") & "/" & totext( Round({Purchorder.CLOSED-LINES}),0,"")

0
 
garyjgsAuthor Commented:
Thank you.  Worked like a charm!
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.