23 Replies Latest reply: Aug 24, 2017 10:34 AM by Linda Pembroke RSS

    Set Analysis - sum max month value

    Linda Pembroke

      Hi all,

       

      I am needing to sum a value (PHARM_NUM_STATUS) for only the max month of the year. I am currently using the below expression, but it is summing the values for all months of the year.

       

      Sum({<PHARM_Year,PHARM_MonthNum>}PHARM_NUM_STATUS)

       

      How can I modify this to only sum the max(PHARM_MonthNum) PHARM_NUM_STATUS?

       

      Thank you in advance.