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 #380 background imageLoading...
Page #380 background image
An 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-up (numeric_exp, integer_exp)
Examples
round-up (-113.6667, 0)
Returns the result: -113
round-up (-113.6667, 1)
Returns the result: -113.6
round-up (-113.6667, -1)
Returns the result: -110
round-up (-113.6667, -2)
Returns the result: -100
round-up (366.2162, 0)
Returns the result: 367
round-up (366.2162, 1)
Returns the result: 366.3
round-up (366.2162, -1)
Returns the result: 370
round-up (366.2162, -2)
Returns the result: 400
Round-Zero
Returns a number rounded toward zero.
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-zero (numeric_exp, integer_exp)
Examples
round-zero (-113.6667, 0)
Returns the result: -113
round-zero (-113.6667, 1)
Returns the result: -113.6
round-zero (-113.6667, -1)
Returns the result: -110
round-zero (-113.6667, -2)
366 IBM Cognos Transformer Version 10.1.1: User Guide

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