Separate result(number) of a count

[#1]

Hi,

In my QV, I've to indicate the number of result. So I 'm using a count like that :

     Count(DISTINCT([bar])) -> 12345.

But How can I custom my resul with spaces like that : 12 345  or 1 234 456.

On Sql we can use concat but here, I don't find.

Can you help me pliz?

Thanks in advice,

[bbi_mba_76]

Hi,

you could use the num function to set the number format as you want

num(Sum([Values]),'# 00')

[#3]

In chart you may try to format your result.

Go to Number Tab.

You may also use num(), like this:

=num(1234,'########### ###')

[alexandros17]

=Replace(Num(1234567890,'#.##0'),'.',' ')

[#5 · Accepted solution]

Thank you all, I 've got my solution :

=NUM(COUNT(DISTINCT([Bar])),'####### ###') 

Just asking :

Why when I delete the blank(space) between '####### ###' then i put the same space in the same place and that don't work ?!