1) round:
for _round, _round(0.0283,3)=0.028
_round(0.0283,2)=0.03
_round(0.0283,1)=0
_round(0.0283,1)=0
2) round up:
use ceiling(numeric_exp),returns the smallest integer greater
than or equal to numeric_exp.
ceiling(0.0283*1000)/1000=0.029
ceiling(0.0283*100)/100=0.03
ceiling(0.0283*10)/10=0
3) round down:
ceiling(0.0283*100)/100=0.03
ceiling(0.0283*10)/10=0
3) round down:
use floor(numeric_exp), returns the largest integer less than or
equal to numeric_exp.
floor(0.0283*1000)/1000=0.028
floor(0.0283*100)/100=0.02
floor(0.0283*10)/10=0
floor(0.0283*100)/100=0.02
floor(0.0283*10)/10=0
I like your post very much. It is very much useful for my research. I hope you to share more info about this. Keep posting cognos online training
ReplyDelete