6 Replies Latest reply: Jul 27, 2018 2:30 AM by sunil kumar RSS

    Conditional set modifiers

    Ashley Kuttler

      Hello I have the following expression to find net collection rate: sum of payments/sum of allowed.

       

      (Sum({<Account = {'2000','2001','2002','2003','2004'}>} Payments)*-1) / (SUM(AmountAllowed))

       

      Fields:

      ID

      Encounter id

      Account (insurance, patient or write off)

      Payments

      Amount Allowed

       

      However, I need to sum payments only for encounter id's  where that have an allowed amount posted (>0)..even if its on another row.

      in other words, if a patient is self pay and no allowed amount was ever posted from an insurance check, I don't want to include those payments.

       

      Hope that makes sense.