1 of 1 people found this helpful
Two calcs should get you there:
if [answer]="Yes" then 1 else 0 end (let's call this [Yes Answers])
and % will be
However, as you ended up with table calcs, I wonder if your data is set up differently from this?
I've already got them coded as 0 (no) and 1 (yes)
so the syntax for % would be: sum(1)/count?
Assuming [Answers] is your dimension name.
You may want to to look at some of the training videos on this website that will help you on your journey into calculations