topic Re: Round up in QlikView

Round up

Mon, 18 Apr 2011 21:14:05 GMT

How can I ROUND UP or ROUND DOWN?

I neet to round up the follow expression:
=SUM([Labor Rate])/COUNT([Labor Rate])

Thanks for your attention

Mon, 18 Apr 2011 21:23:51 GMT

In QlikView: Press F1 on your Keyboard and search for ROUND.

there it is very well described

- QlikJam

IAMDV — Mon, 18 Apr 2011 21:46:05 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!

Tue, 19 Apr 2011 12:47:06 GMT

Thanks DV,

It's completely perfect.

Thu, 16 Feb 2012 17:32:56 GMT

Hi DV,

I've lost the link to your Qlikview blog site, with all the nice tutorials.

There where some intrestring tutorials that I would like to see.

Could you please send your link?

Thanks!

Carter

IAMDV — Wed, 17 Sep 2014 07:06:19 GMT

Hi,

Here you go... I guess it's a bit too late.

www.QlikShare.com

Cheers,