cancel
Showing results for 
Search instead for 
Did you mean: 

I want to convert this SQL query to HANA

Former Member
0 Kudos

Select ( $[$38."U_DISCVALU.1"] / ( $[$38.14.1] * $[$38.11.1] ) ) *100

Accepted Solutions (0)

Answers (2)

Answers (2)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Instead of field number, try to use table name.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this,

Select ( $[$38."U_DISCVALU.1"] / ( $[$38.14.1] * $[$38.11.1] ) ) *100 FROM Dummy

Regards,

Nagarajan

Former Member
0 Kudos

Thanks but I've tried it and it gives me this message (INTERNAL ERROR 3006)