2 Replies Latest reply on Aug 9, 2018 11:42 AM by Paul Brainard

    Sum of Measure for Groups of Dimension Values

    Paul Brainard

      This may be an obvious one, and I may just be experiencing formula paralysis, but what I'm looking to do is a calculation on two groups of values for a specific dimension.

       

      This is what I'm using (which works), but I have to think there's an easier way (like using groups):

       

      IF [Visit Type ID] = '71'

      OR [Visit Type ID] = '67'

      OR [Visit Type ID] = '66'

      THEN [Visit Hours]

      ELSE 0

      END

       

      I have a lot of Visit Types and need them broken down into several groups.  I tried Groups, but it looks like the calculation was picking up Visit Hours from the other values too.

       

      Thanks,

       

      Paul