title: Crystal Report: Conditional Base count in Report footer
body: <p>i have following records in crystal report</p>
  
  <pre><code>ID   Number   Status
   1   001       En
   2   002       En
   3   003       Suc
   4   004       En
  </code></pre>
  
  <p>exacted output   </p>
  
  <pre><code>ID   Number   Status
   1   001       En
   2   002       En
   3   003       Suc
   4   004       En
  
      Total En=  3
      Total Suc= 1
  </code></pre>
  
  <p>i want to count Total in Report Footer  .use below formula but not work</p>
  
  <pre><code>if({sp;1.Status} = "En") then
  count({sp;1.ID})
  </code></pre>