How to format a expression label as currency?

[#1]

Hi,

How to format a expression label as currency value ?

For example - 2000000 should be formatted to #,##0;(#,##0)

Appreciate your help

Thank you

[jerem1234]

You can use num(NUMBER, '#,##0;(#,##0)')

Hope this helps!

[fred_s]

Hi Dimple,

Maybe this way:

money(#,##0;(#,##0))

[#4]

The chart legend show the actual function name and number like num(30000000,'#,##0;(#,##0)')

I am trying to apply the formatting to the label in the expression but it display the actual script in it

[#5]

My bad sorry I will fix it , missed "="

[fred_s]

Is it possible to attach your file?

[jerem1234]

You need to add an =.

Try this in your label:

=num(30000000, '#,##0;(#,##0)')

Hope this helps!