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.



Former Member


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


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