Threaded Mode | Linear Mode

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.

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 3

Code:

[FUNCTION round]

if (<db.connected>)

    db.query "SELECT ROUND(<args>) as val"

    return <eval <db.row.0.val>>

else

    return <args>

endif

But im sure u can do this with eval/fval Smile

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.

***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)

Tastaran · 04-16-2017 02:07 AM

Yes this works Smile

Ty very much.

Threaded Mode \| Linear Mode Converting float to local
Author	Message