Replace TRUNCATE with ROUND while preserving 1 decimal place. This avoids TWO truncation errors! For some reason, MySQL was truncated "1.8" to "1.7".