<div>
Try this syntax... here is a sample of syntax<br />
<br />
Sum({orders.AMOUNT}, {orders.DATE}, &quot;monthly&quot;) % Sum({orders.AMOUNT })<br />
<br />
Groups values in the Amount field by month, and calculates the sum of the values for each month group as a percentage of the sum of the values for the entire report.
</div>


Try this syntax... here is a sample of syntax

Sum({orders.AMOUNT}, {orders.DATE}, "monthly") % Sum({orders.AMOUNT })

Groups values in the Amount field by month, and calculates the sum of the values for each month group as a percentage of the sum of the values for the entire report.

<div>
Thanks! &nbsp;Multipying by 100 was easy.
</div>


<div>
You're welcome.<br />
<br />
&nbsp;But, to be fair, 5teveo probably should have gotten some of the points. &nbsp;His basic suggestion to use the % operator was valid, although his use of different fields in his example formula, and then explaining what that formula was doing, was kind of confusing (at least to me). &nbsp;So, it may be something of a gray area. &nbsp;But he did have the % operator in there.<br />
<br />
&nbsp;If you like, you can use the &quot;Request Attention&quot; link to ask to have the question re-opened, and then split the points between us.<br />
<br />
&nbsp;James
</div>


You're welcome.

 But, to be fair, 5teveo probably should have gotten some of the points.  His basic suggestion to use the % operator was valid, although his use of different fields in his example formula, and then explaining what that formula was doing, was kind of confusing (at least to me).  So, it may be something of a gray area.  But he did have the % operator in there.

 If you like, you can use the "Request Attention" link to ask to have the question re-opened, and then split the points between us.

 James

<div>
<div class="content wysiwyg-content">
I want the this formula to return a %. &nbsp;Like 14%, &nbsp;It comes back now 0.14%<br />
<br />
if Sum ({@Cashless}, {points_of_sale.code}) = 0 then<br />
&nbsp; &nbsp; 0<br />
else <br />
<br />
if Sum ({Vend_Visits.total_revenu<wbr />e}, {points_of_sale.code}) = 0 then<br />
&nbsp; &nbsp; 0<br />
else <br />
<br />
Sum ({@Cashless}, {points_of_sale.code})/Sum<wbr /> ({Vend_Visits.total_revenu<wbr />e}, {points_of_sale.code})
</div>
</div>


I want the this formula to return a %.  Like 14%,  It comes back now 0.14%

if Sum ({@Cashless}, {points_of_sale.code}) = 0 then
    0
else 

if Sum ({Vend_Visits.total_revenue}, {points_of_sale.code}) = 0 then
    0
else 

Sum ({@Cashless}, {points_of_sale.code})/Sum ({Vend_Visits.total_revenue}, {points_of_sale.code})

I have a crystal percentage formula issue

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.