Rounding in Qlikview

[dunnalahk123]

HI,

i am writing some expression as per below

=num ( SUM ({<ScenarioLabel={'Actuals'},NumValue) /
SUM ({<ScenarioLabel={'Actuals'}>} DenValue), '0.#%')

its normal value is 78.26% which is good it is rounding to 78.3%

but same expression if value is 75.75% it is not rounding to 75.8 .. can some one help me here .

problem is after decimal if it is greater than 5 it is rounding if it is equal to 5 it is not rounding as per above example.

[marcus_sommer · Accepted solution]

The rounding happens not on the right digits because it should round to the third digit and not the first, therefore change it to:

num(round(round(Expr1, 0.001) - round(Expr2, 0.001), 0.001), YourFormat)

- Marcus

[dunnalahk123]

Hi Marcus,

Excellent, it works 🙂  Thank You so Much .