This content has been marked as final. Show 2 replies
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]
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.