Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to count all rows of an column where the value is 1. I have tried it with the count-function:
count(column(2)=1)
But it shows me just the number of all rows of the column. How can I create a formula that shows me the right value?
Thank you for your help.
Sum(if((column(2)=1,1,0)
Hello,
the problem is that the result of column(2) is in each line.
So if you want to count where do want to count?
In the title of the chart? In a textbox?
Regards.
I have got a table and I want the result in a diagram.
Maybe this won't fit your requirements if its grander than your example but a simple fix could be within your script.
If(column2=1,1,0) as Column2_1Count
then sum(Column2_1Count)
Sum(if((column(2)=1,1,0)