How can I trim data after numeric data is converted to text?

[TomiCobi]

Hi to all,

I have this formula in one of the crystal reports that I am asked to fix. I just cannot make the result correct.

The formula is:
IF
(table1.field1) = "ConferenceName/SessionName"
THEN
(table1.field1) + " - " + " # of Attendees: " + totext((table2.field1))
ELSE
(table1.field1)


table2.field1 is a numeric field that has 2 decimal points.


The result in the report shows the 2 decimal points. How can I show it without the 2 decimal points. The result should be like this:

ConferenceName/SessionName - # of Attendees: 1 [or 2 or 3 depending on the customer order but without the decimal points]

I am not a programmer nor a developer so I would really appreciate any assistance on this.

Kind regards,
PeterG

 

[IanWaterman]

Changr totext part to

totext((table2.field1), 0)

Ian