<div>
Excellent ... That worked perfectly ... 
</div>


<div>
<div class="content wysiwyg-content">
I have run across an issue that seems so simple but I cannot figure it out. &nbsp;I have multiple rows from a detail table that consist of a number that I need to summarize. I only want to calculate one of the numbers from each ID but everything that I have tried either will not summarize the formula or it totals all rows.<br />
<br />
RefID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Number<br />
1731720 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;586<br />
1731720 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;586<br />
1731720 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;586<br />
1731720 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;586<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
1731411 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;586<br />
1731411 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;586<br />
1731411 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;586<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
1732298 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;600<br />
1732298 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;600<br />
1732298 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;600<br />
<br />
Total &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5,902<br />
<br />
The total that I am trying to get is 1,772 from the above example which consist of each ID and the number that goes with it. &nbsp;I cannot do a distinct row because there are other columns within the &nbsp;rows that do not have distinct values (TimeDate, Actions, etc)<br />
<br />
The I cannot use distinct row counts because not all columns within the report are the same. How can I calculate this correctly?
</div>
</div>


I have run across an issue that seems so simple but I cannot figure it out.  I have multiple rows from a detail table that consist of a number that I need to summarize. I only want to calculate one of the numbers from each ID but everything that I have tried either will not summarize the formula or it totals all rows.

RefID	Number
1731720	586
1731720	586
1731720	586
1731720	586
	
1731411	586
1731411	586
1731411	586
	
1732298	600
1732298	600
1732298	600

Total	5,902

The total that I am trying to get is 1,772 from the above example which consist of each ID and the number that goes with it.  I cannot do a distinct row because there are other columns within the  rows that do not have distinct values (TimeDate, Actions, etc)

The I cannot use distinct row counts because not all columns within the report are the same. How can I calculate this correctly?

Sum of Distinct ID's not calculating as needed

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

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.