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 😊