Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Round
Message
From
06/04/2010 13:28:07
 
 
To
06/04/2010 13:09:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Round
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01458964
Message ID:
01458967
Views:
49
ROUND(value, IIF(value < .95, 1, 0))
>
>i need help to round value as ex.. 0.823 to 0.8 or 68.987 to 69.0 or 56.92 to 57.0
>
>i try round(value,1) it work for 68.987 but for 56.92 round(valuw,0)
>
>i use this code
>
>update newtest set tper=(((ty2010-ty2009)/ty2009)*100/100)*100 where.........&& percentage result
>
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform