Count formula not working

[cquesenbery]

I need some help - I have tried many versions of   " Count( {<[Total Units] = {“>=1”}>}DISTINCT [PatientID] )" and nothing is working.  My original " Count (DISTINCT [PatientID]) "works but what I would like to do is only count distinct patients if the preceding column (Total Units) is greater than or equal to 1.  What am I missing?  Should I try an if statement?  Thanks CQ

[swuehl]

What do you mean with "preceding column"?

[Total Units] need to be a field in the model if you want it to use like that.

How do the field values of [Total Units] look like? How are the fields related?

What is returned from your expression and what do you expect?

[cquesenbery · Accepted solution]

This is what my chart looks like currently - I would like to only count the distinct patients if the total units are greater than 0 or >=1.

[swuehl]

So Total Unit is an expression?

=If("Total Units" >0, Count(DISTINCT PatientID) )

or

If(Column(1) >0, ....)

[swuehl]

Or maybe I misunderstood your request?

How does your expression look like?

[cquesenbery]

That worked - thank you so much for your help!!