<div>
You can't use a summary on a summary function. &nbsp;Also you have WhilePrintingRecords in the formula which forces the evaluation to be after the summaries are calculated.<br />
<br />
<br />
You should be able to use a formula like and then summarize it.<br />
<br />

<pre><code id="code-20-39987378-1">IF GroupName ({@@City}) LIKE 'NON*' THEN 
    {BV_vwrpt_SalesTax.TaxableValue1}
ELSE
    0</code></pre>
<br />
mlmcc
</div>


You can't use a summary on a summary function.  Also you have WhilePrintingRecords in the formula which forces the evaluation to be after the summaries are calculated.


You should be able to use a formula like and then summarize it.



IF GroupName ({@@City}) LIKE 'NON*' THEN 
    {BV_vwrpt_SalesTax.TaxableValue1}
ELSE
    0


mlmcc

<div>
Are you grouping on City?<br />
<br />
Try<br />
<br />
IF ({@@City}) LIKE 'NON*' THEN <br />
&nbsp; &nbsp; {BV_vwrpt_SalesTax.Taxable<wbr />Value1}<br />
ELSE<br />
&nbsp; &nbsp; 0 <br />
<br />
mlmcc
</div>


Are you grouping on City?

Try

IF ({@@City}) LIKE 'NON*' THEN
    {BV_vwrpt_SalesTax.TaxableValue1}
ELSE
    0

mlmcc

<div>
<div class="content wysiwyg-content">
GF3 is a specified group with OTHERS being labeled as NON....<br />
<br />
in the RH I have <br />
<br />
WhilePrintingRecords;<br />
Shared NumberVar NONDISTRICTTAX:=0<br />
<br />
in the GF3 I have<br />
<br />
WhilePrintingRecords;<br />
Shared NumberVar NONDISTRICTTAX:=<br />
IF GroupName ({@@City}) LIKE 'NON*' THEN Sum ({BV_vwrpt_SalesTax.Taxabl<wbr />eValue1}, {@@City})<br />
ELSE 0<br />
<br />
in the RF I have<br />
<br />
WhilePrintingRecords;<br />
Shared NumberVar NONDISTRICTTAX:=NONDISTRIC<wbr />TTAX;<br />
<br />
<br />
Why cant I get a grand total of only the Like 'NON*' as indicated above?
</div>
</div>


GF3 is a specified group with OTHERS being labeled as NON....

in the RH I have 

WhilePrintingRecords;
Shared NumberVar NONDISTRICTTAX:=0

in the GF3 I have

WhilePrintingRecords;
Shared NumberVar NONDISTRICTTAX:=
IF GroupName ({@@City}) LIKE 'NON*' THEN Sum ({BV_vwrpt_SalesTax.TaxableValue1}, {@@City})
ELSE 0

in the RF I have

WhilePrintingRecords;
Shared NumberVar NONDISTRICTTAX:=NONDISTRICTTAX;


Why cant I get a grand total of only the Like 'NON*' as indicated above?

Running Total based on Specific Order of Group.

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.