Totaling only some records on report to show correct percentage

[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

[June7]

Both which fields?

Need to know more about data structure. If you want to provide db for analysis, follow instructions at bottom of my post.