Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to readjust the format of my expression in a straight table to have first the number the the Country in a nice realignment:
LOAD * INLINE [
Name, Country, Score
Mark, France, 200000000
John, France, 190000000000
Claudia, France, 1200
Marcus, England, 50000000
Berta, Austria, 1500000000
];
Thank you,
Raphael
You can get this....
1) use this expression
num(Score ,'#,##0') & Repeat(' ', Max(TOTAL Len(Country)) + 2 - Len(Country)) & '(' & Country &')'
2) Use monocode font (i used Courier New), but feel free to pick another one... here is the list List of monospaced typefaces - Wikipedia
Hi,
Go to -> Presentation -> select your expression ->Data Text -> Right Alignment
PFA
Hirish
PFA
Almost there , but if my Countries name are not same lenght - for example England in the example I gave or in new example USA and Australia - it is not aligned - so guess need on top some kind of function, please see example of issue using your solution:
You can get this....
1) use this expression
num(Score ,'#,##0') & Repeat(' ', Max(TOTAL Len(Country)) + 2 - Len(Country)) & '(' & Country &')'
2) Use monocode font (i used Courier New), but feel free to pick another one... here is the list List of monospaced typefaces - Wikipedia
Perfect, many thanks