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