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.




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


      Thank you in advance.