Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached, changed the label expression and in the presentation tab set the orientation to right
didn't get you, what is the desired output?
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=',';
from presentaion tab--select ur field--set alignment as Right
Thanks, Total 1.250 is on left side in column and I need Total 1.250 on right side.
See attached, changed the label expression and in the presentation tab set the orientation to right
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
apply the above technique.
hey,whr is the orentaion in presentaion tab? very funny...
Values should be on right side, strings without values on left side!