Format number in Text in Chart

[guyvermeiren]

Hello,

I would like to fomat my numbers in my calculated Text in Chart.

I tried this to have a thousand separator but without success

='Target='&Num#(vTargetOpptyNL,'#.#')

Any idea how to ?

Thanks,

Guy

[erichshiino · Accepted solution]

num# will convert a text into a number. You need num() that will make the opposite:

try this:

='Target='&Num(vTargetOpptyNL,'#,###', '.', ',')

That's if your thousand sep. is , and your decimal sep is .

If  vTargetOpptyNL is an expression, you may need to evaluate it:

='Target='&Num($(vTargetOpptyNL),'#,###', '.', ',')

or

='Target='&Num($(=vTargetOpptyNL),'#,###', '.', ',')

Hope it helps,

Erich