Skip to Content
0
Former Member
Aug 09, 2012 at 06:27 PM

Case statement

980 Views

Hi Expert's

I'm trying to create a case statement which looks at the value of a measure and based on whether it is greater than or less than 50,000 it should give me a character or dimension object back as my result.

Definition:

Case

WHEN (dbo.fact_Opportunity.TCV_Amt_USD <= 50000) THEN 'Under 50k'

WHEN (dbo.fact_Opportunity.TCV_Amt_USD >= 50000) THEN dbo_dim_OpportunityOwner.Level_1_Presentation_Name

Else 'Null'

End

The issue I am having is when I put Else 0, I get a data type error.

When I put Else 'Null' the query just runs forever

When I define the statement as :

Case

WHEN (dbo.fact_Opportunity.TCV_Amt_USD <= 50000) THEN 'Under 50k'

Else dbo_dim_OpportunityOwner.Level_1_Presentation_Name

End

That runs forever too.

Thank You 😊