title: Avoiding divide by zero error when using the OVER() clause even after using nullif
body: <p>The error I'm getting is</p>
  <blockquote>
  <p>Divide by zero error encountered.</p>
  </blockquote>
  <p>My code looks like:</p>
  <pre><code>Select A, B, C, nullif(100*count / sum(count) OVER (partition by A, B), 0) as Share
  </code></pre>
  <p>Any ideas why this may be throwing me an error?</p>