Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Are you trying to mix count and sum here?
I believe i am...... I want a count of MRNS that have more than one unit.... hope that makes sense