<div>
Try this<br />
<br />
Click REPORT &nbsp; --&gt; &nbsp;SELECTION FORMULA --&gt; GROUP<br />
<br />

<pre><code id="code-20-40622131-1">if Sum ({@terms}, {@pl and dept and name}) = 0 then 
     False
Else
     (Truncate (Sum ({@terms}, {@pl and dept and name})) / Sum ({@headcount EndofMth}, {@pl and dept and name}) * 100) &gt;= 10 </code></pre>
mlmcc
</div>


Try this

Click REPORT   -->  SELECTION FORMULA --> GROUP



if Sum ({@terms}, {@pl and dept and name}) = 0 then 
     False
Else
     (Truncate (Sum ({@terms}, {@pl and dept and name})) / Sum ({@headcount EndofMth}, {@pl and dept and name}) * 100) >= 10 

mlmcc

<div>
Thank you! &nbsp;I got the &quot;Division by zero&quot; error with the Truncate portion of the formula hi-lighted.
</div>


Thank you!  I got the "Division by zero" error with the Truncate portion of the formula hi-lighted.

<div>
Exactly what I needed. &nbsp;Thank you!
</div>


<div>
<div class="content wysiwyg-content">
CRV10 - I have a report with one group, LOCATION. &nbsp;In that group footer I have a formula that calculates turnover percentage. &nbsp;I already have detail suppressed. &nbsp; How can I suppress the group if the turnover percentage &lt;&nbsp;10 percent ?<br />
<br />
The formula is: &nbsp;<br />
if Sum ({@terms}, {@pl and dept and name}) = 0 then 0 else<br />
<br />
Truncate (Sum ({@terms}, {@pl and dept and name})) / Sum ({@headcount EndofMth}, {@pl and dept and name}) * 100
</div>
</div>


CRV10 - I have a report with one group, LOCATION.  In that group footer I have a formula that calculates turnover percentage.  I already have detail suppressed.   How can I suppress the group if the turnover percentage < 10 percent ?

The formula is:  
if Sum ({@terms}, {@pl and dept and name}) = 0 then 0 else

Truncate (Sum ({@terms}, {@pl and dept and name})) / Sum ({@headcount EndofMth}, {@pl and dept and name}) * 100

crystal group suppression based on formula

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.