Round up

[#1]

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

[#2]

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

there it is very well described

- QlikJam

[IAMDV · Accepted solution]

Please use this...

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

OR

=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!

[#4]

Thanks DV,

It's completely perfect.

[#5]

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]

Hi,

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

www.QlikShare.com

Cheers,

DV