How to show number with comma

[suvechha_b]

Hi,

How can I the number as :

217053472 as 217,053,472 .

To Display the values for SALES/DEMAND I used Text Object.

Is there any other to display the values

My Output should look like :

[sunny_talwar · Accepted solution]

Try using Num() function

Num(YourExpression, '#,##0')

Replace YourExpression with the existing function you have

[trdandamudi]

Use Num function and see a sample below:

Num(Sum(Amount) / Business_Days_Available,'#,##0.0')

[Kushal_Chawda]

=Num(sum(SalesPerDemand),'#,#00')

Use your actual expression

[swuehl]

The num() function should do what you want, sometimes you need to explicitely define both separators to make it work correctly:

Num(YourExpression, '#,##0.','.',',')

[Peter_Cammaert]

Actually, the num() function becomes interesting after the second parameter, because parm 3 & 4 allow you to change decimal and thousands separators.

If for example, ThousandSep = '.' and DecimalSep = ',' by default (because they're set like that in your system/load script), you can change them in the UI by using

=num(SumValue, '#,###.00', '.', ',')

See also QV Desktop Help articly for function num(). It comes with some good examples.

Peter