hey ppl,
iam thinking to difficult cant get it to work so hope u can clear my mind a bit.
got collumn A that has different values in text example (yes,no,other,null) so i filter to only get (yes,no)
now i want to count the numbers yes and numbers no seperatly as output
example (yes 40) (no 60)
can u tell me what the count should look like?
step 2
i want the total of (yes and no) (100) then i want the percentage no for the total so 60/100*100 =percentage
it looks so siple to create but cant get it to work properly
Hi Bartburg,
I don't know if you've got a second column in your data that you can use, column B for example. If you have you can just create a calculation of count([Column B]). And the percentage could then be something like count([Column B]) / count([ColumnB] for report)
If you haven't got a Column B then you could just create a column called Tally which you'd just put 1 in. Then you can do the same sort of thing, but you can use total this time instead of count...it just depends on your preference.