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

(Omkar Konda) #1

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

(Aleksi Alkio) #2

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

(Omkar Konda) #3

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

(Omkar Konda) #4

Never mind, both are working

(Aleksi Alkio) #5

Yes they will.