topic Ceil,Floor functionality in QlikView

Ceil,Floor functionality

Tue, 17 Dec 2013 17:40:20 GMT

Hi,

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

VishalWaghole — Tue, 17 Dec 2013 17:46:30 GMT

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 — Tue, 17 Dec 2013 17:48:25 GMT

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