<div>
A running total by definition works on each record. &nbsp;A formula in the report footer is only executed once so there is nothing to add up.<br />
<br />
What is it you are trying to do?<br />
<br />
mlmcc<br />
<br />

</div>


A running total by definition works on each record.  A formula in the report footer is only executed once so there is nothing to add up.

What is it you are trying to do?

mlmcc



<div>
 I think you basically want to produce a total of the result of that formula. &nbsp;Do you actually want a running total, or just a grand total? &nbsp;&quot;Running total&quot; sort of implies that you want to see the total as it's accumulated (every time something is added to it). &nbsp;But all that you would normally see in the &quot;report footer&quot; would be the grand total.<br />
<br />
&nbsp;Which is basically my long-winded way of asking the same question as mlmcc. &nbsp;:-)<br />
<br />
&nbsp;The answer is probably going to be to accumulate the total in a variable, which you could do in that same formula, but exactly how you handle it will depend on which type of total you want.<br />
<br />
&nbsp;James<br />

</div>


I think you basically want to produce a total of the result of that formula.  Do you actually want a running total, or just a grand total?  "Running total" sort of implies that you want to see the total as it's accumulated (every time something is added to it).  But all that you would normally see in the "report footer" would be the grand total.

 Which is basically my long-winded way of asking the same question as mlmcc.  :-)

 The answer is probably going to be to accumulate the total in a variable, which you could do in that same formula, but exactly how you handle it will depend on which type of total you want.

 James


<div>
All I would like is the total
</div>


<div>
<div class="content wysiwyg-content">
How can I create a running Total on my Report footer for the following calculation:<br />
<br />
EvaluateAfter({@Total Group Scrap Time});<br />
numberVar dur;<br />
(dur * 41.58 / 3600) +({@Total Quantity of Scrap}*{PartMaster.Materia<wbr />lCost})<br />
<br />
<br />

</div>
</div>


How can I create a running Total on my Report footer for the following calculation:

EvaluateAfter({@Total Group Scrap Time});
numberVar dur;
(dur * 41.58 / 3600) +({@Total Quantity of Scrap}*{PartMaster.MaterialCost})




Running Total Calculations

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.