
1. Re: Avoiding average of averages. Calculating open rate.
Tracy Rodgers Mar 8, 2013 12:53 PM (in response to Jay Miller)Hi Jay,
Would you be able to post the packaged workbook (twbx file)?
Hard to see what's going wrong. One reason you may be getting something other than what you suspect would be if your measures aren't aggregated. You may try:
iif(sum([DeliveriesImplicit])=0,0,sum([UniqueOpens])/sum([DeliveriesImplicit]),0)
Tracy

2. Re: Avoiding average of averages. Calculating open rate.
Jay Miller Mar 8, 2013 2:37 PM (in response to Jay Miller)That worked perfectly. I just copied and pasted your formula in there. Thanks!!

3. Re: Avoiding average of averages. Calculating open rate.
Alex Cook Feb 6, 2015 9:10 AM (in response to Jay Miller)Hey gang, I'm having a related problem with getting the correct totals for unique opens. The results I want are simply opens, unique opens, and the relevant rates, by email recipient+email name. It seems that I can get either the absolute number or the rate correct, but not both. When I use the twopass aggregation (Analysis>Totals>Total All Using>Sum), I get the correct total for unique opens, but then the percentage is incorrect.
The correct totals should be 13 opens, for an overall open rate of 118% (13/11), and 9 unique opens with an overall unique open rate of 69% (9/13). I have read through many of the posts on customizing totals (esp here: Customizing Grand Totals – Part 2  Drawing with Numbers and Not getting grand totals for complex table calculations) but am still having trouble. If anyone can assist it would be much appreciated. Or if you can direct me to a post that has the solution (so far I've found none) then that would be helpful too.
Thanks,
Alex

Unique Opens Issue.twbx 113.9 KB
