count

[bartburg]

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

[BigChris]

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.