Dollar symbol for Amounts

[#1]

Hi,

I implemented Bar Chart, in X-Axis i  wrote Sum(Amounts) as a Expression,

How to Assign Dollar symbol for this Amounts.

Please help me.

Thanks,

MLNR

[Anonymous]

goto properties, tab "numbers" and select your Expression and

Change to Money format

[Anonymous]

Go to the Number tab of the Chart.

• Select the Expression
• Set it to Money
• Give it a format pattern something like
  • $#,##0.00;($#,##0.00)

[#4]

Hi Narayana,

First select expression ,then go to Number.Do changes as mentioned on image ,Also use $ symbol in Symbol field .

[MarcoWedel]

Or use an expression like

Money(Sum(Amounts) )

instead of Sum(Amount)

[#6]

may this help you

=Money(Sum(Amount)) // this create format like $ 25,23.00

=Money(Sum(Amount),'$ #,##,###') // this create format like $ 25,23