12 Replies Latest reply: Feb 1, 2013 10:27 AM by cjcamp22 RSS

    Calculating Year To Date Accumulation Expression

      I am trying to show average cost per member per month in a bar chart and I want to show this as a year to date figure.  For example, for March, I would want an expression that would show this:

       

      (January Cost + February Cost + March Cost) / (January Members + February Members + March Members)

       

      I see where I can click 'Full Accumulation' but this just calculates it this way:

       

      (January Cost / January Members) + (February Cost / February Members) + (March Cost / March Members)

       

      So I essentially want to change the order of operations and I am guessing there is a way to do this in the expression formula.  Does anyone have an idea?