I am trying to write a formula that does a count on a data set with a WHERE clause. I have 2 columns of data: NAME and TASKS. I want to do a count of the NAME WHERE that person has 1 or more TASKS.
I am not sure how to put the WHERE clause into the crystal formula. Is there another type of function/operators I should be using?