Phetrov
-
Posts
1 -
Joined
-
Last visited
Phetrov's Achievements
Newbie (1/7)
0
Reputation
-
Hi guys, looking for some help with rounding up a decimal. I am working on DB2 9.7. The following is the query i have used to receive the correct decimal, but i need the decimal to round up (e,g. 74.70 should be 75 not 74) , RS1.TOTAL_PNTS , RS1.SOLD_PNTS , RS1.TOTAL_MAT , DECIMAL ( RS1.SOLD_PNTS*1.00 / RS1.TOTAL_PNTS*1.00 , 10, 5 ) * 100 , RS1.TOTAL_PNTSVAL , RS1.SOLD_PNTSVAL , DECIMAL ( RS1.SOLD_PNTSVAL*1.00 / RS1.TOTAL_PNTSVAL*1.00 , 10, 5 ) * 100 Thanks