Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conditionally formatting numeric fields
Message
 
 
To
24/04/2008 17:35:18
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01312990
Message ID:
01313016
Views:
12
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform