Skip to Content
avatar image
Former Member

Format numbers in column chart

Hi all,

I want to display formated numbers in tooltip of column chart.

Instead 60000 display 60,000...

Is it possible?

VC7 SP15 Flash runtime.

Thanks,

Ola

Edited by: Ola Agiv on Sep 18, 2008 2:01 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 18, 2008 at 09:23 PM

    Hi..

    I think you can use the numeric function NSTR(n, mask), whereby n represents your @value and the mask has to be set to 'C'. This should turn the 60000 into 60.000.

    If you want to have a comma instead of the dot you can put the NSTR function into the REPLACE function.

    Example:

    REPLACE(NSTR(@value,'C'), '.', ',')
    

    Greets, Jochen

    Edited by: Jochen Schmitz on Sep 18, 2008 11:30 PM

    Add comment
    10|10000 characters needed characters exceeded