Formatting a dimension field to currency format($#.##)

[#1]

Hi,

I have a chart that thas a price field that I want to format so that its in a currency format i.e. 26 to read $26.00. The field a dimension as opposed to expressions.

Does anyone know how I can format this dimension field so that it appears in currency format? I tried to use the money# function like this

money#(Price, '$#' , '.' , ',') but it doesn't work. I'm trying to apply the money# function in the chart. Do I have to do this in the load statement instead?

thanks,

[Miguel_Angel_Baeyens · Accepted solution]

Hello Mike,

It should work in both script and expression editor.

If the field is actually a number or a numeric value, then you just need to

Money(Field)

This will take by default, without any modifier, the value of the variable "MoneyFormat" that is at the top of your main tab in the script editor.

Hope that helps.

[#3]

Thanks so much. So easy once you pointed that out. Much appreciated.

[Anonymous]

It can be done from the front end as well: Document Properties - tab Number. That is, you can change format without reloading.