Expression in straight Table - Align right with Padding

[#1]

I need to keep some space (2 spaces) between the actual number(right aligned) and the border. I tried using TEXT(NUM(Sales,'$ ###,#0')) & '  ' and few other methods (chr(10), RPAD etc).

Anyone tried? Please respond. Thanks, Ganesh.

[#2]

Anyone got a chance to try this? I tried that this is possible to Pivot table but not working for Straight Table. In Pivot table I add a blank column and remove borders before that column. It gives the same effect.

[Anonymous]

Hi,

How about:

=SUM(1000)&'     '&CHR(15)

Right align Text and Numeric.

Kind regards

Niklas

[ecolomer]

See this option:  

=Num(Importe, '#.##0,00 € ')&'      '&'|'

[#5]

Thanks Niklas. That worked. Thanks all for your time.

[#6]

Unfortunately it doesn't work in Webview. I am assuming it wont in Accesspoint too.

Just marked unanswered to get some more inputs if i can.

[Anonymous]

Are you sure?

It is just a question of how many spaces you put in.

See WebView example below with and without spaces.

[#8]

Sorry Niklas, I am trying to see what could be wrong. Your screen does show it is working. It is not the number of spaces, I tried and not working.