rouding last digits to 2 decimal places
Posted: Thu Oct 27, 2011 9:59 am
Hi,
Please give me a solutions for the below question:
my input data :
filed1
1.223
0.003
45.89
0.00006
45.8934
My output data :
field1 field2
12.23 10
0.03 10
45.89 1
0.06 1000
4589.34 100
so the out put data should be rounded to last 2 decimal places as an example shown above.
and also need the values that are multiplied to get the output values into the seperate field .
Please give me a solutions for the below question:
my input data :
filed1
1.223
0.003
45.89
0.00006
45.8934
My output data :
field1 field2
12.23 10
0.03 10
45.89 1
0.06 1000
4589.34 100
so the out put data should be rounded to last 2 decimal places as an example shown above.
and also need the values that are multiplied to get the output values into the seperate field .