Rounding problem

[saimahasan]

Hi,

I am stuck with rounding off. Basically i am trying to get the sum and then take the rounding value but wherever there is 5 after decimal it does not round whereas for rest of the values it rounds.

Please find attached sample data.

[Anil_Babu_Samineni]

Read this where we use floor() and ceil() in qlikview?

[swuehl]

Have a look at

Rounding Errors

You could load your values in as cents, like

LOAD Round(MARKET_VALUE*100) as MARKET_VALUE_CENT,    

          ...

FROM ...;

Then do you sums, and only show the aggregated value divided by 100 to show your value in Dollar (or whatever your currency is)

=Round(Sum(MARKET_VALUE_CENT) /100, 0.01)