Discussion Board for collaboration related to QlikView App Development.
Does anyone knows, why the result of Ceil(1092/364) is 4 ??? It should be 3 Or am I wrong?
Seems like rounding error problem
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.
One work around would be to do this