Skip to Content
0
Former Member
Apr 22, 2009 at 08:28 AM

Decimal Part in query

26 Views

Dear All,

I have generated a query in query generator.SELECT T2.[LastPurPrc], T2.[LastPurCur] as 'Purchase Currency', (T2.[LastPurPrc]0.02) as 'Additional Cost', ((T2.[LastPurPrc]102)/100 )as 'Costing Sheet Value' FROM OITM T2 JOIN WOR1 T1 ON T1.ItemCode = T2.ItemCode WHERE T0.[Itemcode] = [%0]

I have obtained the calculated value for additional cost and costing sheet value. But its showing value up to 2 decimal places, whereas i need it for 6 decimal places.

The values of LastPurPrc is up to 6 decimal places.

Similarly i need the values of Costing sheet value and additional cost to be 6 decimal places.

For ex : if LastPurPrc value is : 100.50

then i need the value of additional cost to be displayed as 2.010000 (100.50*0.02) instead of 2.01.

Similarly for Costing sheet value.

Please help me in this regard,

Thanks and regards,

Venkatesh.R