topic AW:Re: Round up in QlikView

Round up

Mon, 18 Apr 2011 21:17:14 GMT

How can I round up or round down an expression?

I need to round up the follow expression:

=SUM([Labor Rate])/COUNT([Labor Rate])

Actually the result value is 85.076987481, I need something like: 85.08

how can I do it?

Thanks;
Best regards;

Round up

IAMDV — Mon, 18 Apr 2011 21:44:35 GMT

Please use this...

=Round(SUM([Labor Rate])/COUNT([Labor Rate]), 0.01)

=Ceil(SUM([Labor Rate])/COUNT([Labor Rate]), 0.01)

Use FLOOR for...

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

=floor( 2.4 ) returns 2

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

=ceil( 3.88 , 0.1 ) returns 3.9

Please mark the post answered, if this helps!

Round up

Tue, 19 Apr 2011 21:57:05 GMT

Thanks!

AW:Re: Round up

Tue, 19 Apr 2011 22:18:09 GMT

Hello kellyhbastos

if you recognized a post as the correct solution, would you mark this post as a varified answer. So the thread will be marked green and can be seen as solved.

Rgeards, Roland

Round up

IAMDV — Tue, 19 Apr 2011 23:33:24 GMT

kellyhbastos - Roland is right. Please mark the post as verified if it works for you. Or we can help you further...