Problem with formatting in KPI-object

[#1]

Hello,

how shall I do to get the value 3342394 formatted in the KPI-object  in the same

way as it is in the variable vG.KPI1 ?

kindly

Håkan

[Anonymous]

This will work:

=num(3342394,'# ##0','.',' ')

second argument in red is single quote space single quote

[sunny_talwar]

I did point that out to the OP, not sure if he has already tried this or not, but I agree that this should work

[Anonymous]

Ah Yes, sorry sunny. I worked on this and got around to something else then hit post a while after without looking at the updates.

[sunny_talwar]

You don't have to be sorry my friend. I was just trying to reiterate to the OP that this should have worked. Not holding you against posting

[Clever_Anjos]

Please try this:

=replace(num(3231235,'#.##0'),'.', ' ')

[#7]

hello,

it works when you write the number direct, but when you have it in an variable it doesn´t

work.

[Anonymous · Accepted solution]

how is your variable being used?

$(vVariable) or just vVariable?

[#9]

Hello,

at last is it solved with  '=num($(vG.KPI2),'# ##0','.',' ')'

Thank you all for your help.