Skip to Content
avatar image
Former Member

I want to convert this SQL query to HANA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 02 at 10:47 PM

    Hi,

    Try this,

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

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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

  • Jan 02 at 11:12 PM

    Instead of field number, try to use table name.

    Add comment
    10|10000 characters needed characters exceeded