how can i convert 7,895kgs into 7.8 tons ? i donโt want it as 7.895 or 7.9 or 7.0
FLOOR([WEIGHT]/100)/10.0 and then show that decimal column with on edecimal.
@Aleksi_Alkio FLOOR is rounding to lowest value (7.0) . DECIMAL([weight]/100)/10 is working fine.
Never mind, both are working
Yes they will.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |