Straight table dimension format

[#1]

Hi,

I've got a straight table. I am able to change the format for expressions on Number tab in Properties.

How would I change the data format for dimensions?

I have some fields which need to be displayed as currency. At the moment, data is only displaying as numbers.

Thanks

[CELAMBARASAN · Accepted solution]

You need to add as calculated dimension

like Num(CurrencyField,'$###,###.##')

Hope it helps

[#3]

Thanks for this. Had to change it a little bit to:

=Num(Currency_Field, '£#,##0;-£#,##0')

Thanks for your help!