Round off in Qlikview

[dunnalahk123]

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,

Hk

[neelamsaroha157 · Accepted solution]

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

with your expression -

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