Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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.
Does this along is working -> sum(Amount)*sum(ExchangeRate)?
yes..it is working
What is your expression for varCurrencySymbol?
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.
Symbol means is that image?? or Text??
If varCurrencySymbol is a text maybe you could try this:
=$(varCurrencySymbol)&''&sum(Amount)*sum(ExchangeRate)
or another option:
='$(varCurrencySymbol)'&''&sum(Amount)*sum(ExchangeRate)
Hi,
Try like this
=Num(sum(Amount)*sum(ExchangeRate), varCurrencySymbol & '#,##0')
Hope this helps you.
Regards,
Jagan.