rounding down instead of up

[#1]

Hi,

Can someone explain how to stop chart rounding down incorrectly?

Ther raw data which the chart is referring to shows average to be 7.85; however, on the chart when we set to 1 decimal is rounding down to 7.8 when it should round up to 7.9.

Please help.

Chris

[#2]

current expression is

Avg

([PI2. Overall satisfaction with this service area])

so does this become:

Floor(Avg([PI2. Overall satisfaction with this service area]))

[#3]

Hi Bill,

Thanks for this but I will have to be honest and say I dont fully understand it.

For the issue I'm having we have  question which our customers rate us on from 1-10. The 20 records we have bring an average of 7.85 when you selct the data in excel. I dont understand why in Qlikview when we have the same calcuation ([PI2. Overall satisfaction with this service area]) it produces a result of 7.8 when 1 decimal but more crucially how we get solve it both in this instance and how we can avoid in the future?

Chris

[Anonymous]

Chris

Have a look at this thread.  The "solution" is a bit of a frig but works.

Round() function giving sometimes incorrect results

Regards,     Bill

[tcullinane]

no, floor will always round down, (or ceil will always round up) which appears to answer the title question, but not the problem.

I think something like Massimo has said, multiplying by 10,100  or whatever to give the required degree of accuracy then dividing to display with correct places of decimal is a good option.