I have the following Case Statement:
Case When PCYTD_1.PC_YTD - PCB_1.PC_Base >= dbo.tblPIF_Size.Goal_PC Then Dense_Rank() Over (partition by PCB_1.Terr Order By PCYTD_1.PC_YTD - PCB_1.PC_Base desc) Else 0 End as Rank
It states that When a total ( PCYTD_1.PC_YTD - PCB_1.PC_Base) is >= to a Goal then Rank that result. Otherwise (Else) show 0.
HOWEVER I do NOT want the 0 I want the 0 to be 'NOT MET'
My problem is that I have a data type issue as the first parts are int and my else would be char. I tried to Cast, but no luck.
Can someone asssit. Thank you.
Open in new window