Rounding problems in Qlikview

[#1]

Hi,

I have an expression which sums up parts, it could be for e.g. 0,4 parts or 0,6 parts. Does anyone know if it's possible to arrange in Qlikview that the parts are automatically rounded so that 0,4 parts = 0 and 0,6 parts = 1. In Qlikview now it is already rounded but when I export to excel the decimals shows.

Thanks!

Sofie

[swuehl · Accepted solution]

Try to add rounding to your expression, not using a number formatting rounding:

=round(sum(PARTS))

[rajni_batra]

in expression use round() function
round("Your expression")

Regards,

rajni

[#4]

Thanks a lot!

[#5]

Thanks a lot!

[#6]

Are you using  Round(Number,1)  ?