Conditional Counting

[#1]

Hello,

I have a question (probably super simple for most of you)...

I need to create an expression where I am able to distinctly count records in column 1 if the records in column 2 are greater than zero. Here's an example that has no particular relevance:

Group                    Cost

A                              $1.21

B                              $3.16                             

C                              $0.92

D                              $0.00

E                              $10.22             

F                              $0.00

The answer would be 4 because I would count A, B, C, and E since they are all greater than $0.00.

How do I do this?

Thanks in advance:)

[mikecrengland]

Try something like:

Count({<Cost = {">0"}>} Distinct Group)

mike

[MK_QSL]

=COUNT({<Cost = {">0"}>}DISTINCT Group)

or

=Count({<Group = {"=SUM(Cost)>0"}>}DISTINCT Group)

[#4]

Thank you Mike!