when set my chart to display full accumulation , it unable display currency sign.

[paulyeo11]

Hi All

I have Chart A and Chart B , both are similar , except that Chart B i set the chart accumulation full,

My question is why Chart B be not able to display currency sign ?

Paul

[sushil353]

Hi,

use num function like: Num(SUM(Value), '#.##0 $'),

HTH

Sushil

[sushil353 · Accepted solution]

Hi,

Goto number tab and select the Money option.

HTH

Sushil

[sushil353]

Check out the attached application..

i have created a clone object for chart B and hiding according to Org and S$

[paulyeo11]

may i know what you make change on the chart , it is you only set to money at number tab ?

[sushil353]

Since, when you select the Org then it show $ sign without S prefix

and

When you select the S$ from listbox it shows S$ .

That is why i have created two same charts for Chart B and conditionaly hiding the one chart from presention tab..

HTH

Sushil

[paulyeo11]

Thank i understand how to do it , so the track is change to money at numnber tab to make it work,