Set Analysis Question

[#1]

Hi All, I could use a little help...

I'm trying to write a formula that will idenitify the number of "MRN's" (person identifier), for only those who have charges greater than Zero.... I have written the formula this way.... Would someone identify where i'm off?

=sum({$<TransactionType = {'Room Adj', 'Room Charge'}, AcctPerAndYear = {$(=max(AcctPerAndYear)), {

DISTINCT MRN}>} Units)

[rbecher]

Are you trying to mix count and sum here?

[#3]

I believe i am...... I want a count of MRNS that have more than one unit.... hope that makes sense