LOB Type in group by Clause - SAP HANA - Custom Column Error

[Anonymous]

Hello,

I have datasource as SAP HANA. The odbc and connection everything works fine. 

But I am getting this weird issue when I am creating a custom column. Moreover, if I remove [CUST_NAME] from the formula then it works fine. But I do need CUST_NAME in the formula. Not able to narrow it down. TIA.

This is the step where it is failing.

Thanks,

-RK

[amitchandak]

@Anonymous , Can make sure [Group Name] , [#"Sold to party"] and [Cust_Name] all three are of text data type before this step

[Anonymous]

@amitchandak  I made all of them text in PowerBI but it still didn't work. I tried this and this seemed to work, can't quite understand why....

Old Formula = if [Group v Sold to] = "G" then [GROUP_NAME] else [#"Sold-to party"]&" - "&[CUST_NAME] New Formula = if [Group v Sold to] = "G" then [GROUP_NAME] else if [Group v Sold to] <> "G" then [#"Sold-to party"] &" - "&[CUST_NAME] else 1