1 Reply Latest reply: May 9, 2017 3:08 PM by Sunny Talwar RSS

    Apply set analysis to whole expression instead of each function?

    Michael Marchese

      This works:

       

      Sum({<ID={8}>} m_count1) + Sum({<ID={8}>} m_count2) + Sum({<ID={8}>} m_count3)

       

      But it involves specifying the same set expression repeatedly.  Is there a way to apply set analysis to the expression as a whole?  I'm looking for something like this:


      {<ID={8}>} Sum(m_count1) + Sum(m_count2) + Sum(m_count3)
      


      Note: I know that in this particular case, I could do this:

       

      Sum({<ID={8}>} m_count1 + m_count2 + m_count3)

       

      But sometimes you can't get away with doing the math pre-aggregation.