Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
coxanagi
Contributor II
Contributor II

Ceil

Hello

Does anyone knows, why the result of Ceil(1092/364) is 4 ??? It should be 3 Or am I wrong?

3 Replies
sunny_talwar

Seems like rounding error problem

Rounding Errors

surendraj
Specialist
Specialist

Ceil will round the value when it exceeds (means 3.0003 should result to 4)

If you want 3 as a result you can go with floor(as it takes integer part)

else you can go with round based on requirement.

sunny_talwar

One work around would be to do this

=Ceil(Round(1092/364, 0.1))

=Ceil(Round(1092/364, 0.00000000001))