<div>
Try this<br />
<br />
Create 2 formulas<br />
<br />
Name - IsPositive<br />
If {YourField} &gt;&nbsp;0 then<br />
&nbsp; &nbsp; 1<br />
Else<br />
&nbsp; &nbsp; 0<br />
<br />
Name - IsNegative<br />
If {YourField} &lt;&nbsp;0 then<br />
&nbsp; &nbsp; 1<br />
Else<br />
&nbsp; &nbsp; 0<br />
<br />
<br />
You can then summarize these as sums and do the calculations<br />
<br />
Sum({IsPositive}) / Count({YourField})<br />
<br />
Sum({IsNegative}) / Count({YourField})<br />
<br />
mlmcc
</div>


Try this

Create 2 formulas

Name - IsPositive
If {YourField} > 0 then
    1
Else
    0

Name - IsNegative
If {YourField} < 0 then
    1
Else
    0


You can then summarize these as sums and do the calculations

Sum({IsPositive}) / Count({YourField})

Sum({IsNegative}) / Count({YourField})

mlmcc

<div>
Most of the points should have gone to mlmcc. &nbsp;I only posted a couple of alterations to his suggestion. &nbsp;You can use the &quot;Request Attention&quot; link under your post to ask to have the question re-opened, and then split the points between us.<br />
<br />
&nbsp;James
</div>


Most of the points should have gone to mlmcc.  I only posted a couple of alterations to his suggestion.  You can use the "Request Attention" link under your post to ask to have the question re-opened, and then split the points between us.

 James

<div>
<div class="content wysiwyg-content">
I am working on a report that will show results by account. &nbsp;I have grouped the report by account. &nbsp;I am trying to show how many positive and negative results were reported for each account and their percentage rate. &nbsp;I have tried several &nbsp;different formulas and methods to get this and keep coming up against a brick wall. &nbsp;Any suggestions.........
</div>
</div>


I am working on a report that will show results by account.  I have grouped the report by account.  I am trying to show how many positive and negative results were reported for each account and their percentage rate.  I have tried several  different formulas and methods to get this and keep coming up against a brick wall.  Any suggestions.........

Counting specific items in a grouped field

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.