Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can use the calculated dimension =Num(FieldName,'£#,##0.00;(£#,##0.00)')
Regards
VIjay
Hi,
You can use the calculated dimension =Num(FieldName,'£#,##0.00;(£#,##0.00)')
Regards
VIjay
Hi,
With your dimension =MONEY(Field)
Regards,
Sokkorn Cheav
Thanks a lot for this quick response!
Helps me a great deal
Works also!