Have you tried something like below? I think it will exclude 8's. You might want to exclude them from the denominator as well.
IF [Value]>=6 and [Value] != 8 then 1 ELSE 0 END
/ SUM([Number of Records])
Hi Ivan! Thanks for your suggestion. Unfortunately, this is excluding the "8" responses in the numerator, but not removing those records from the denominator.
So, on one item (for example) the total number of responses is 347. 30 of those are "8" responses, so 317 are 1-7.
With 60 "6" responses and 147 "7" responses, my total top 2 box responses is 207.
What I'm trying to get is the percentage calculated by 207/317 (65%). This calculation gives me 207/347 (60%). It's using the right numerator, but the denominator includes all of the responses including the 8's instead of just the responses that were 1-7.
Any suggestions? Thanks again!
2 of 2 people found this helpful
Give this a try, it should exclude 8 from the denominator. Let me know how it works.
SUM(IF [Value]>=6 and [Value] != 8 then 1 ELSE 0 END)
/ SUM(IF [Value] !=8 THEN [Number of Records] ELSE 0 END)
Woohoo! You're a lifesaver, Ivan! That worked beautifully. And now I know how to do that. :-)
Thanks so much for your very prompt and helpful response!