Skip to Content
0
Dec 15, 2011 at 04:20 AM

Case Statement Issue..Help Needed

12 Views

Hi Guys,

I want to create a measure and it uses two fields.

1. Interval_Measure ( has two values '15 min' and '60 min' )

2. Event_ID ( Has list of events)

I want to create a logic something as follows:

Case whren Interval_Measure= '15 min' then count(Event_ID)424 Else Count(Event_ID)24 end*

but this case statement is not working...

Help Needed