Set Anlysis and Number format

[leocattqv]

Hi all,

I have the following formula to calculate Defective Parts per Million

sum({<[Supplier.No_Approved Parts] = {'>=1'},

[Supplier.MONTH] = {'*2014*'}>} [Supplier.QTY Rejected])

/ Sum([Supplier.No_Approved Parts]) *1000000

What I am trying to do is have a number format of ('#,###,##0')

Im not getting where to place the format.

Any suggestions?  I promise to give the correct credit

thanks, in advance

-L

[jaimeaguilar · Accepted solution]

Hi,

if you're using this formula in a chart as an expression(pivot, straight table, bar chart, etc) then all you have to is to go to properties and in number tab you can define how you want to visualize that number. But if you're using this formula in other object like a text box then enclose your formula with num function:

num(Formula, '#,##0')

so your format will be like 1,234,000

regards

[leocattqv]

that worked, thank you