+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: Script Help (/Forum-Script-Help)
+--- Thread: Converting float to local (/Thread-Converting-float-to-local)
Converting float to local - Tastaran - 04-12-2017 09:02 AM
Hello,
I have float number and i need to round it on decimal (local) ... ex. : 67.598 and i need : 68.
How can i do it ?
and another question, how can i format float number to n. places ? ex. : 5.7893 to 5.79
Thanks.
RE: Converting float to local - escribano - 04-12-2017 03:27 PM
Hi there... i'm using math funcion at the database, running a query like:
Code:
<eval <round (100/3)>> // return 3Code:
[FUNCTION round]
if (<db.connected>)
db.query "SELECT ROUND(<args>) as val"
return <eval <db.row.0.val>>
else
return <args>
endifBut im sure u can do this with eval/fval
RE: Converting float to local - Tastaran - 04-12-2017 07:40 PM
Well I have this :
float.uc=253.16
float.dmg=<floatval ((<float.UC>*1100)+500)/1000>
and I need float.dmg -> local.dmg with rounding.
RE: Converting float to local - Coruja - 04-15-2017 03:01 PM
usually sphere always drop the decimal on all formulas instead round it up/down based on last digit
so instead round the value (which you must create manually an extra script just for that), you can just use <feval <float number here>> to turn 67.598 into 67
long story short: <floatval 321/123> will return the float result (eg: 2.609756 -> float values always have 6 digit precision) and <feval 2.609756> will drop the decimal making it an integer value (eg: 2)
RE: Converting float to local - Tastaran - 04-16-2017 02:07 AM
Yes this works
Ty very much.