Currency symbol

[#1]

=varCurrencySymbol&''&sum(Amount)*sum(ExchangeRate)

I have the above expression in the text object and it is working fine but the same expression is not working in the chart.Any idea why ?

Thank you.

[sunny_talwar]

Does this along is working -> sum(Amount)*sum(ExchangeRate)?

[#3]

yes..it is working

[sunny_talwar]

What is your expression for varCurrencySymbol?

[#5]

never mind ..I tried below exp and it is wroking fine.

=Num(Sum(Amount)*Sum([ExchangeRate]),varCurrencySymbol &''&'#,##0')

varCurrencySymbol  has diff currency symbols.

Thank you very much.

[HirisH_V7]

Symbol means is that image?? or Text??

[rodri_morales]

If varCurrencySymbol is a text maybe you could try this:

=$(varCurrencySymbol)&''&sum(Amount)*sum(ExchangeRate)

or another option:

='$(varCurrencySymbol)'&''&sum(Amount)*sum(ExchangeRate)

[jagan]

Hi,

Try like this

=Num(sum(Amount)*sum(ExchangeRate), varCurrencySymbol & '#,##0')

Hope this helps you.

Regards,

Jagan.