Chart Dimension: Text format

[danosoft]

I have this problem, i have a chart with some Dimensions and some Expressions; so for Expression i can in the tab number set the formatting (like you see in the picture), but in the Dimension i not have that kind of thing... how can i format my dimension for make it visible in this format:  #.##0,00;(#.##0,00);-    ? thanks

[m_woolf]

Try using num()

[danosoft · Accepted solution]

I find it, need to use NOT in Text format but directly in the Dimension expression in this way:

=Num(GEN_CONSUMO_MENSILE,'#.##0,00;(#.##0,00);-')

[vishsaggi]

you can use Money() function too.

[danosoft]

Thanks