<div>
it worked but I had to put parens around the sums to make sure the calculation took place first and then the test for zero. &nbsp;having the test for zero with the parens resulted in funky percents if divisor was not zero. &nbsp;Thanks though, good job!
</div>


it worked but I had to put parens around the sums to make sure the calculation took place first and then the test for zero.  having the test for zero with the parens resulted in funky percents if divisor was not zero.  Thanks though, good job!

<div>
<div class="content wysiwyg-content">
Hello, I am having a problem with access 2010 report equation. &nbsp;I'm trying to get the percent to show zero if LYDayDol = 0. &nbsp;I keep getting the error ...wrong number of arguments...<br />
<br />
=IIf([LYDayDol &lt;&gt;0,Sum([ActDayDol])-Sum([<wbr />LYDayDol])<wbr />/Sum([LYDa<wbr />yDol]),0)
</div>
</div>


Hello, I am having a problem with access 2010 report equation.  I'm trying to get the percent to show zero if LYDayDol = 0.  I keep getting the error ...wrong number of arguments...

=IIf([LYDayDol <>0,Sum([ActDayDol])-Sum([LYDayDol])/Sum([LYDayDol]),0)

Divide by zero

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.