Number formatting....

[leocattqv]

Hi All, I have a set of code that I would like to set the number format after an equation. Does anyone know how to do this?  format would be '(#,#00)'

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

[NCMR.Type] = {'Vendor'},

NCMR.SITE = {'TJM', 'VST'}>} [NCMR.SUSPECT_QUANTITY]) /

Sum({<NCMR.SITE = {'TJM', 'VST'}>} [Supplier.No_Approved Parts]) *1000000

[jerem1234]

use the num function:

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

[NCMR.Type] = {'Vendor'},

NCMR.SITE = {'TJM', 'VST'}>} [NCMR.SUSPECT_QUANTITY]) /

Sum({<NCMR.SITE = {'TJM', 'VST'}>} [Supplier.No_Approved Parts]) *1000000, '(#,#00)')

[leocattqv · Accepted solution]

That Worked, thank you

[#4]

Not cool Leo, not cool...

[jerem1234]

You're welcome! Please mark any answers that were helpful or correct...

[leocattqv]

ummmm, whats not cool?

[#7]

I believe Jeremiah provided you with the correct answer, my fair man.  In situations like this here in our Qlik Community that would be an appropriate time to provide the person who provided you with the correct answer the points for said correct answer.  It is, as Jacob said "not cool" to give this accolade to yourself when a hard working young man worked his fingers to the bone trying to assist you.