
1. Re: Tablea calculation/calculate the rate
Andrew Watson May 16, 2016 6:34 AM (in response to Dilyana Suleymanova)COUNT(IF [Arten] = 'Email Optin' THEN [WDEM] END)/COUNT([WDEM])

2. Re: Tablea calculation/calculate the rate
Dilyana Suleymanova May 16, 2016 6:59 AM (in response to Andrew Watson)HI Andrew, thank you for your replay. I tried it out and this is my result:
the Rate of optins is 15,15% . But it is wrong. The correct answer is 26% (5 EMail Optins / 19 sent print mailing). I tried to rewrite the formula to
COUNT(IF [Arten] = 'Email Optin' THEN [Arten] END)/COUNT([Arten]) But I get the same result. Do you have any ideas why? And how can I get the correct answer, Please see my workbook attached.
Thank you!
Best

3. Re: Tablea calculation/calculate the rate
Andrew Watson May 16, 2016 7:03 AM (in response to Dilyana Suleymanova)Ok, I understand, I didn't calculate beforehand. I provided the count of all Opt Ins / ALL where you want the count of all Opt Ins / Count of all that are NOT opt in. This is provided below.
COUNT(IF [Arten] = 'Email Optin' THEN [WDEM] END)/COUNT(IF [Arten] != 'Email Optin' THEN [WDEM] END)

4. Re: Tablea calculation/calculate the rate
Dilyana Suleymanova May 16, 2016 7:11 AM (in response to Andrew Watson)unfortenately with this formula I get wrong result 17,86%
if I rewrite formula to COUNT(IF [Arten] = 'EMail Optin' THEN [Wdem] END)/COUNT(IF [Arten] != 'Thema 1' THEN [Wdem] END) > I get also wrong result 35,71%.
I don't understand where is the mistake. It would be very kind from you if you could take a look one more time. Thank you!

5. Re: Tablea calculation/calculate the rate
Andrew Watson May 16, 2016 7:26 AM (in response to Dilyana Suleymanova)I can't open your workbook as it's in a later version of Tableau. However the formula looks correct. I attached a workbook containing the above formula based on your formula and the 26% is returned.

forum_post.twbx 6.9 KB
