EasyManuals Logo

IBM Cognos User Manual

IBM Cognos
411 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #379 background imageLoading...
Page #379 background image
Returns the result: 366
round-down (366.2162, 1)
Returns the result: 366.2
round-down (366.2162, -1)
Returns the result: 360
round-down (366.2162, -2)
Returns the result: 300
Round-Near
Returns a number rounded to the nearest value.
The integer_exp value determines the position that is rounded. A positive
integer_exp value acts on the digits to the right of the decimal point. A negative
integer_exp value acts on the digits to the left of the decimal point. An integer_exp
value of zero rounds the number and removes the decimal places.
Syntax
round-near (numeric_exp, integer_exp)
Examples
round-near (-113.6667, 0)
Returns the result: -114
round-near (-113.6667, 1)
Returns the result: -113.7
round-near (-113.6667, -1)
Returns the result: -110
round-near (-113.6667, -2)
Returns the result: -100
round-near (366.2162, 0)
Returns the result: 366
round-near (366.2162, 1)
Returns the result: 366.2
round-near (366.2162, -1)
Returns the result: 370
round-near (366.2162, -2)
Returns the result: 400
Round-Up
Returns a number rounded up.
The An integer_exp value determines the position that is rounded. A positive An
integer_exp value acts on the digits to the right of the decimal point. A negative
Appendix F. IBM Cognos Transformer Expression Editor 365

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM Cognos and is the answer not in the manual?

IBM Cognos Specifications

General IconGeneral
DeveloperIBM
Data Sourceflat files
Operating SystemMicrosoft Windows
LicenseCommercial
Input SourcesSQL databases, Excel, CSV
PlatformMicrosoft Windows