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

    Sum if on multiple values

    Anna Chan



      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.




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


          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.