Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CSTR cutting off trailing zeros
Message
From
28/04/2006 14:37:40
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Crystal Reports
Category:
Formulas and functions
Title:
CSTR cutting off trailing zeros
Miscellaneous
Thread ID:
01117622
Message ID:
01117622
Views:
56
Hello,
I am using a formula field to concatonate 2 decimal values separated by a dash. However, I want the result to trim all unneccesary trailing zeros and decimal points for both values.

For example, I want values 10 and 8.5 to be "10 - 8.5". Now it shows "10.00 - 8.50".

The formula I am using is CSTR({field1}) + " - " + CSTR({field2}).

Any helpful hints?
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform