title: Cognos Query Calculation
body: <p>I want to calculate outage percent and here is my query :</p>
  
  <pre><code>[Time Diff]*100/[Time Total]
  </code></pre>
  
  <p>This is query calculation. But here is the deal this calculation end up with zero. <strong>Time Diff</strong> is smaller than <strong>Time Total</strong>. Layout calculation gives right result. It should be like this after calculation : <strong>0.1879458</strong>. But query calculation gives <strong>zero</strong>.</p>
  
  <p>What should I do ? What is the deal ?</p>