Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New Contributor II

Ceil

Hello

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

Tags (1)
3 Replies
Highlighted

Re: Ceil

Seems like rounding error problem

Rounding Errors

Valued Contributor

Re: Ceil

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.

Highlighted

Re: Ceil

One work around would be to do this

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

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