Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Number format

I have an expression

=(NUM(SUM(IF(pkgNME='Bronze', [Net Sold Qty])),'#,###.')/vBronzePKG)

That every time I enter the equation, gives me a result of 714.0916184.

I have the number format at the end of this expression to avoid the decimals.

Am i entering the format of this equation correctly.

1 Solution

Accepted Solutions
sunny_talwar

My bad, try this

=Num(Sum({<pkgNME = {'Bronze'}>} [Net Sold Qty])/vBronzePKG, '#,###.')

View solution in original post

6 Replies
sunny_talwar

Try this

=Num(Sum(If(pkgNME='Bronze', [Net Sold Qty]))/vBronzePKG),'#,###.')

sunny_talwar

Better yet, try this

=Num(Sum({<pkgNME = {'Bronze'}>} [Net Sold Qty])/vBronzePKG),'#,###.')

evansabres
Specialist
Specialist
Author

Both of these give a result of 'Garbage after the expression: ","

sunny_talwar

My bad, try this

=Num(Sum({<pkgNME = {'Bronze'}>} [Net Sold Qty])/vBronzePKG, '#,###.')

sunny_talwar

or this

=Num(Sum(If(pkgNME='Bronze', [Net Sold Qty]))/vBronzePKG,'#,###.')

evansabres
Specialist
Specialist
Author

Thank you for your help.