1 of 1 people found this helpful
create a calculated field along the lines of:
COUNTD(IF [Responder Flag] = 'Yes' THEN [FieldToCount] END)/COUNTD(IF [Responder Flag] != 'Yes' THEN [FieldToCount] END)
Remove the Responder Flag from the Columns shelf and put that new calculated field in the text shelf. Should work, fingers crossed.
I think this should work. Create these 2 calcualations. Call the first one "Count of Yes"
COUNTD(IF [Responder Flag]="Yes" THEN [Responder Flag] END)
Call the second one "Count of No":
COUNTD(IF [Responder Flag]="No" THEN [Responder Flag] END)
And finally your % calculation will look like this:
[Count of Yes]/[Count of No]
And then convert that to a percentage and I think that will do the trick. Let me know how this works out.
Edit: I removed the SUM from in front of my final calculation as it is already an aggregate!
That's worked, genius! Thank you for your help and the quick response.
Thanks for your help!
yup Andrew's solution worked a treat!