realigning num and string combination format

[Anonymous]

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

[HirisH_V7]

Hi,

Go to -> Presentation -> select your expression ->Data Text  -> Right Alignment

PFA

Hirish

[Anil_Babu_Samineni]

PFA

[Anonymous]

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:

[sunny_talwar · Accepted 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

[Anonymous]

Perfect, many thanks