[img http://i.imgur.com/uUIFt.gif 1

[jbaughman]

I would like the report variance to only show the percent from total pages and actual clicks where both fields are populated. The actual clicks are added from a different table at the first of the following week. Is there an easy way to do this or should I just live with it the way it is?

Thank you in advance!

Jeff

 

[dhookom]

What value would you like to see under total pages in the totals row? From your description I expect you could use something like:

  =Sum((IsNull([Actual Clicks)+1) * [Total Pages])

Duane
Hook'D on Access
MS Access MVP

 

[jbaughman]

Thanks dhookom!! Sorry about my vague post, but you were able to read thru it because that's what I needed. I knew there was something I could do with the IsNull, but I could not figure it out. I included the calculation you provided in the report variance calculation so that I could keep my totals correct.

Here's how the report variance expression reads now and it works!

=((Sum([Actual Clicks])-Sum((IsNull([Actual Clicks])+1)*[Total Pages]))/Sum([Actual Clicks]))

Thanks again!!