Changing Number Format

[#1]

Hello,

I would like to change the number format of a Column in a Chart Straight Table. I select the column under dimensions because I have to suppress it when the value is null. (I know its possible if I select it as an expression).

I assume I can adjust the format also of a dimension but I'm a bit confused here, I see 'Text Format' but do not know what code I should type to set it correct.  (Needs to be money-format)

Txs

[vijay_iitkgp · Accepted solution]

Hi,

You can use the calculated dimension  =Num(FieldName,'£#,##0.00;(£#,##0.00)')

Regards

VIjay

[Sokkorn]

Hi,

With your dimension =MONEY(Field)

Regards,

Sokkorn Cheav

[#4]

Thanks a lot for this quick response!

Helps me a great deal

[#5]

Works also!