<div>
I think you could be a litle more clear explaining some of your actual code in order to get the right answer.
</div>


I think you could be a litle more clear explaining some of your actual code in order to get the right answer.

<div>
you need to use &quot;if then else&quot; syntax to check if the divisor is zero, like this:<br />

<pre><code id="code-20-40358748-1">If {Current YTD} ={Previous YTD} then 0 else ({Current YTD} - {Previous YTD}) / {Current YTD} * 100</code></pre>
</div>


you need to use "if then else" syntax to check if the divisor is zero, like this:


If {Current YTD} ={Previous YTD} then 0 else ({Current YTD} - {Previous YTD}) / {Current YTD} * 100

<div>
Thanks Michael!!!<br />
<br />
<br />
Steve
</div>


<div>
<div class="content wysiwyg-content">
I have two currency fields, Current YTD and Previous YTD.<br />
<br />
I need a formula that shows the percentage increase or decrease. &nbsp;I've tried a few things but I'm getting Division by 0 errors. &nbsp;Either value can be &quot;0&quot;.<br />
<br />
I need something to display 50, 100, or -50, -100, etc, etc<br />
<br />
I'm braindead - can any of you help?<br />
<br />
Thanks in advance!<br />
<br />
<br />
Steve
</div>
</div>


I have two currency fields, Current YTD and Previous YTD.

I need a formula that shows the percentage increase or decrease.  I've tried a few things but I'm getting Division by 0 errors.  Either value can be "0".

I need something to display 50, 100, or -50, -100, etc, etc

I'm braindead - can any of you help?

Thanks in advance!


Steve

&quot;Percentage Difference&quot; formula needed

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.

&quot;Percentage Difference&quot; formula needed

"Percentage Difference" formula needed