Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Conditionally formatting numeric fields
Message
 
 
À
24/04/2008 17:35:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01312990
Message ID:
01313016
Vues:
14
>Naomi,
>its ok for me to receive a reply after your session. Anyway it is 23:30 already in Holland.
>I would like to have my number formatted to 999,999.99 + only if a condition is true, otherwise the format will remain 999,999.99.
>So if condition is true it would show as e.g. 78,796.00 + and if condition is false it could be 67,560.00 or (in case it is negative -67,560.00)
>Bye for now,
>will read you tom.
>
>Koen

So, what again is the problem?
iif(myCondition, alltrim(transform(myNumber, "@ 999,999,999.99")) + " + ", transform(...))
Check transform command for details, I write from memory (no VFP here, of course).
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform