title: Why Crystal Report Formula is not working to Group Data
body: <p>I am using formula fields and have created this <code>formula</code> to group data on the basis of <code>null or not</code>. but it is not working and always group data in just one <code>Completed</code> group. Why ?  </p>
  
  <pre><code> if (Not IsNull({MRSReportProject_MRSReportClass.Actiontaken})) 
      and (IsNull({MRSReportProject_MRSReportClass.actioncomplete})) then "Pending"
  
      else if (Not IsNull({MRSReportProject_MRSReportClass.actioncomplete})) then "Completed"
  
  else "Nothing";
  </code></pre>