May 10 2012, 06:35 PM
I am creating a report with the following information: there are 400 studies, 11 study types, and up to 25 strategies that each study can include. For each strategy, I need to know 1) how many studies use that particular strategy and 2) what the percentage breakdown is of study types. I was able to create a report that provides the percentage of study type/strategy for all studies but the calculation is as a percentage of all studies rather than just within a specific strategy. I used Report Wizard and this is the calculation that is showing: =Count([Study Design])/[AccessTotalsStudy Design].
Any guidance is appreciated, thank you!
May 10 2012, 06:53 PM
If you are saying that you want a "per strategy" calculation, you'll need to tell Access to "group by" strategy.
That way, each strategy will have its own section, and the calculation can be "per section" (i.e., per strategy).
May 10 2012, 07:01 PM
Thank you for your response. I have the report grouped by Strategy and then by Study Design with Study Design totaled. This is still only giving me a calculation for all studies rather than by section. I've been working on this for awhile, and I feel like I must be missing something that is quite obvious...
May 10 2012, 07:29 PM
This is the calculation in the Study Design footer: =Count([Study Design])/[AccessTotalsStudy Design]/[AccessTotalsStudy Design]
and this is the calculation in the Strategy footer: =Count(*)/[AccessTotalsStudy Design]
The number I want is this: Count([Study Design])/[AccessTotalsStudy Design]/[AccessTotalsStudy Design] divided by Count(*)/[AccessTotalsStudy Design]
but I'm having trouble communicating this to Access...
May 10 2012, 09:13 PM
I figured it out - =(Count([Study Design])/[AccessTotalsStudy Design])/[AccessTotalsPercentStudy Design]
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here