Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ceil,Floor functionality

Hi,

Please explain Ceil, Floor Examples with little briefly some time I am getting Rounding Errors(Different Value).

1 Solution

Accepted Solutions
VishalWaghole
Specialist II
Specialist II

Rounding of x upwards to the nearest multiple of base with an offset of offset. The result is a number.

Examples:

ceil( 2.4 ) returns 3

ceil( 2.6 ) returns 3

ceil( 3.88 , 0.1 ) returns 3.9

ceil( 3.88 , 5 ) returns 5

ceil( 1.1 , 1 , 0.5 ) returns 1.5

View solution in original post

2 Replies
VishalWaghole
Specialist II
Specialist II

Hi Raja,

If your value is 3.2 then Ceil function will return 4

and

Floor function will return 3.

Thanks and Regards,

Vishal Waghole

VishalWaghole
Specialist II
Specialist II

Rounding of x upwards to the nearest multiple of base with an offset of offset. The result is a number.

Examples:

ceil( 2.4 ) returns 3

ceil( 2.6 ) returns 3

ceil( 3.88 , 0.1 ) returns 3.9

ceil( 3.88 , 5 ) returns 5

ceil( 1.1 , 1 , 0.5 ) returns 1.5