Format numbers in column chart

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi,

I tried your soln on my System as below.

1.Input field L1

2.Expression Field E1 with formula :NSTR(@L1, 'C'),

3.Exepression Field E2 WIth formula :REPLACE(NSTR(@L1,'C'), '.', ',')

I Had given Input for L1 as 10000.

the output of E1,E2 is 10,000 Means output of both formulas returning same output.

Could you plesae check this once .

where you testing this

i am working on SP16.

Thansk,

Govindu

[Former Member · Accepted solution]

Hi Jochen,

Thank you for reply.

The NSTR formula returns TEXT and TEXT values can't be used as series of the chart...

In my case I want to format values displayed as tooltip on the bars of my bar chart...

Anybody? Any ideas?

Thanks,

Ola

[Former Member · Accepted solution]

Hi Ola,

Did you ever get a solution to your problem? I am also having the same issue - that the tooltip text within the graph is showing the raw number rather than a formatted number with commas. When trying to use a data type defined as text with the formatting applied as the data source, the graph would not display as you stated. So, any alternatives that you found would be appreciated.

Thanks,

Alan

[Former Member · Accepted solution]

Hi, you have more info for IF formule condition sintaxis.

We need implementing for multimple checklist in Form, then filter is condition for next Table Detailled.

Where i can get more details for sintaxis and examples in formules the VC ?

Thank you.

[Former Member · Accepted solution]

[Tale of VC functions|http://help.sap.com/saphelp_nw70ehp1/helpdata/en/48/d10a2013ba2b63e10000000a42189d/frameset.htm]