Text in Chart

[#1]

I added some text to a gauge chart.: = ('Margin: ' &'$'&Sum(Margin)) .

The result of this line is: Margin: $363301,02

Now I'm trying to change the notation to only: Margin: $363.301

I know I can use the NUM function for this, but I dint succeed.
Appreciate the help.

Regards

[#2]

it should work with num. Show us the code that how you implemented Num function.

It is a bad practice, but you can divide it by 1000 and use round function to deal with decimal.

Ryan

[#3]

Did you add num like this ? = 'Margin: $' & Sum(num(Margin)) It should work.

[#4 · Accepted solution]

Thanks for the tips.

I worked it out the following way to get a satisfying result:

=

'Margin: $' & NUM(Sum(Margin), '#.##0')