Commas on numeric

[manoranjan_d]

Hi all,

I m using the expression to get the legend inside the stack bar.

=Dual([Dimension 1]&'-'&Sum(Value),Sum(Value))

but i want commas in number ti show it, when i use number tab and selecting the numeric format to get commas i m losing the dimension 1 on the stack bar

[swuehl · Accepted solution]

Add the num() function to your text representation:

=Dual([Dimension 1]&'-'& Num(Sum(Value),'#,##0.0','.',','),Sum(Value))

Adapt the format code as needed.