1 Reply Latest reply on Oct 4, 2016 5:36 PM by Wesley Magee

    Sum if on multiple values

    Anna Chan

      Hi

       

      Is it possible to get a conditional sum, ex. (sum values for a, b, c). Similar to a sum if, but involving multiple values?

       

      Please let me know.

       

      Thanks,

      Anna

        • 1. Re: Sum if on multiple values
          Wesley Magee

          Anna,

          This should be doable as an if/then statement. It will depend on whether you want an alternative aggregation (avg, min, etc) or just to combine members of a dimension. Here's an example:

           

           

          If [Dimension] = 'a' or [Dimension] = 'b' Then SUM([Metric]). END

           

           

          Let me know if you have any other questions.

          -Wesley