Sunday, April 6, 2014

How to use _round up and down in Report Studio

1) round:

for _round, _round(0.0283,3)=0.028
_round(0.0283,2)=0.03
_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:

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

1 comment:

  1. 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