title: Multiplication in redshift
body: <p>I am new to Redshift, trying to do multiplication in my SQL as mentioned below </p>
  
  <pre><code>Case  When COALESCE(height * width * length * weight, 0) = 0 then ...
  </code></pre>
  
  <p>getting below error message, </p>
  
  <blockquote>
    <p>Invalid operation: Resulting scale overflows maximum precision
    Details:</p>
  </blockquote>
  
  <p>Can someone please guid me.</p>