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))




      Encounter id

      Account (insurance, patient or write off)


      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.