Round off in Qlikview

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

HI,

Can some one help me here

i have my Value 1673.47574 and i wrote as below

Round ( SUM ({<ScenarioLabel={'Actuals'}>} NumValue),0.1)

which gives me 1673.5 which is Good

but i need value like below

1,673.5

how can i get this.

Best Regards,

Re: Round off in Qlikview

neelamsaroha157 — Tue, 07 Aug 2018 17:59:33 GMT

Try it with Num function like - Num(YourField, '##,###.0')

with your expression -

Num( SUM ({<ScenarioLabel={'Actuals'}>} NumValue),'##,###.0')