<div>
I am not sure what you are trying to do?<br />
<br />
Why do you need to ignore the 0 values?<br />
<br />
mlmcc
</div>


I am not sure what you are trying to do?

Why do you need to ignore the 0 values?

mlmcc

<div>
Exclude it from what? &nbsp;The report (ie. don't display it), or don't include it in some calculation, or ...?<br />
<br />
&nbsp;James
</div>


Exclude it from what?  The report (ie. don't display it), or don't include it in some calculation, or ...?

 James

<div>
The zero values are not needed in the report, but unfortunately, some values have 0. I need them to be excluded from the calculation.
</div>


The zero values are not needed in the report, but unfortunately, some values have 0. I need them to be excluded from the calculation.

<div>
<div class="content wysiwyg-content">
I have a formula in my running total that will obtain the maximum value out of the listing.<br />
Sometimes, the only value is a zero. Is there a way I can write the formula to still obtain the maximum value and in cases where the only value is a zero, to exclude it?
</div>
</div>


I have a formula in my running total that will obtain the maximum value out of the listing.
Sometimes, the only value is a zero. Is there a way I can write the formula to still obtain the maximum value and in cases where the only value is a zero, to exclude it?

Maximum Function to Exclude Zero

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.