4 Replies Latest reply: Feb 2, 2016 3:28 PM by Kristina Stephenson RSS

    set analysis for trending by rolling years

    Kristina Stephenson

      Hi All,

       

      I'm working on creating a trend chart (trending by rolling years) of $ per member per year for patients with claims data.

       

      I have the following dimensions:

      Rolling Year End Date= EndDt

      Payment Category= PaymentCat

       

      I'm struggling to get my expression to work for all scenarios:

       

      PMPY $=(SUM({<EndDt>}pay_adj_amt)/SUM({<EndDt>}MemberMonths))*12

       

      Currently, the above expression works if I only have 1 patient selected. If I have more than 1 patient selected, it appears as if the member month aggregation only counts member months for patients in the specific payment category, versus member months for all patients selected. How should I adjust the set analysis to account for this?

       

      Thanks!

       

       

      ***See test QVW attached and see comment below for further explanation