Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Screen Value

I have a query

SELECT ($[$38.U_QTY.Number] * $[$38.U_RATE.Number]) / $[$38.11.NUMBER]

This query gives me some result e.g. 230, but the real output is 230.23, so i want to pick the decimal value in my query,how can it be possible.

Regards

replied

Try this one:

SELECT (cast($[$38.U_QTY.Number] as dec(19,6)) * $[$38.U_RATE.Number]) / $[$38.11.Number]

(Then the system will not evaluate the expression as an integer one.)

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question