This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

how can i convert 7,895kgs into 7.8 tons ? i ...

Posted on 08-22-2018 05:00 PM
Omkar_Konda
New Member
Reply posted on --/--/---- --:-- AM

how can i convert 7,895kgs into 7.8 tons ? i don’t want it as 7.895 or 7.9 or 7.0

0 4 299
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
Aleksi_Alkio
New Member
Reply posted on --/--/---- --:-- AM

FLOOR([WEIGHT]/100)/10.0 and then show that decimal column with on edecimal.

0 Likes

Posted on --/--/---- --:-- AM
Omkar_Konda
New Member
Reply posted on --/--/---- --:-- AM

@Aleksi_Alkio FLOOR is rounding to lowest value (7.0) . DECIMAL([weight]/100)/10 is working fine.

0 Likes

Posted on --/--/---- --:-- AM
Omkar_Konda
New Member
Reply posted on --/--/---- --:-- AM

Never mind, both are working

0 Likes

Posted on --/--/---- --:-- AM
Aleksi_Alkio
New Member
Reply posted on --/--/---- --:-- AM

Yes they will.

0 Likes
Top Labels in this Space