Skip to Content

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

Issue with converting

Hello All,

after looking at some advice on this page on how to convert, i've came up with the following:

SELECT T0.[ItemCode], ((CAST(T0.[U_Attribute1] AS decimal(18,6))/1000)*(CAST(T0.[U_Attribute2] AS decimal(18,6))/1000)*(CAST(T0.[U_Attribute3] AS decimal(18,6))/1000)) as [Attribute 5] FROM OITM T0

can anyone see where i've gone wrong here? because the query executes fine, it just doesn't bring any data through.

cheers,

Jamie

Former Member
replied

Hi,

Try this :

SELECT T0.[ItemCode],CAST(T0.[U_Attribute1] AS decimal(18,6)) * CAST(T0.[U_Attribute2] AS decimal(18,6)) * CAST(T0.[U_Attribute3] AS decimal(18,6)) FROM OITM T0

Thanks

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