Format Total

[Anonymous]

Hi,

two table-chart with different total mode. How can i format total in table-chart two on right side with correct format.

Regards Stefan

[maleksafa]

didn't get you, what is the desired output?

[fvelascog72]

I undertand you want 1.250 instead 1,250

In expression use:

= 'Total ' & Num(Sum(Value),' #.##0')

In script you must change:

SET ThousandSep='.';

SET DecimalSep=',';

[buzzy996]

from presentaion tab--select ur field--set alignment as Right

[Anonymous]

Thanks, Total 1.250 is on left side in column and I need Total 1.250 on right side.

[stigchel · Accepted solution]

See attached, changed the label expression and in the presentation tab set the orientation to right

[awhitfield]

Hi Stefan,

Change the Label From

= 'Total ' & Num(Sum(Value),' #,##0.', '.', ',')

TO:

= 'Total ' & Num(Sum(Value),'#.##0', ',', '.')

Just swapping the decimal and thousand seperators round

Andy

[buzzy996]

apply the above technique.

[buzzy996]

hey,whr is the orentaion in presentaion tab? very funny...

[Anonymous]

Values should be on right side, strings without values on left side!