Rounding in Qlikview

dunnalahk123 — Sat, 16 Nov 2024 03:31:33 GMT

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.

Re: Rounding in Qlikview

sunny_talwar — Mon, 20 May 2019 17:30:46 GMT

Have you seen this thread? Rounding Errors