formatting a number in a popup text

[#1]

I have a google geo map where I want to display the quantities of sales next to each bubble.

What I want to do is display the customer name and their sales. This should be easy but i can't seem to format the sales number inside the expression.

I can format the expression sum(Quantity) under the Numbers tab, but when I want to concatenate the expression with some other fields, the number formatting doesn't work anymore.

example:

865434 can easily be formatted to 865,434 using the Number tab

but what I cant' seem to do is

something like:

CustField & ' ' & 'Sales:' & sum(Quantity)

where the result will give me: Customer A Sales: 865,434

[johnw · Accepted solution]

CustField & ' Sales: ' & num(sum(Quantity),'#,##0')

Though I'd probably use a money() format instead of a num() format.

[#3]

Thanks John! It works