9 Replies Latest reply: Sep 21, 2016 9:28 AM by Sarah Nguyen RSS

    % by month

    Sarah Nguyen



      Dimension: MonthYear and then FinancialClass

      Measure: -Sum({<[TransPostedDateCalendar.MonthsAgo]={">=1<=4"}>}Payment_Total)


      How do I calculate % by month? E.g. For June 2016, total payments was $27,888. The financial class *Unmapped* would be 79%, Blue Cross would be 9%, etc. I need each month to total 100%.

      Thank you.