Hello,
I'm trying to calculate the open rate of two columns in one of my sheets. Opens/Delivered. I've tried numerous calculations and created several field calculations, but the number is still incorrect...
In this screenshot the campaigns are subtotaled. Can anyone help?
It appears that the error is happening in measures. It appears to reSUM everything, even though all campaigns are already totaled/Summed.
Thanks
So, your original formula was in fact correct, where it's SUM([U Opens]/SUM([Delivered]).
I think the issue was where I was pulling the data from. Here's what I did and it worked.1. I created a calculated field
2. Pulled the above calculation from the Measures Values SUM([U Opens]/SUM([Delivered]) (NOT the Measures area, which I might have been doing before) - Saved
3. I then pulled this new value into columns and changed the format to percentage and it worked!
Thanks again for your help.
