Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CSTR cutting off trailing zeros
Message
De
15/05/2009 12:37:17
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
 
 
À
28/04/2006 14:37:40
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Crystal Reports
Catégorie:
Formules et fonctions
Divers
Thread ID:
01117622
Message ID:
01400158
Vues:
35
>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?

Bump for this question - I have the same issue again and I don't remember how I fixed it.
Very fitting: http://xkcd.com/386/
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform