Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
My bad, try this
=Num(Sum({<pkgNME = {'Bronze'}>} [Net Sold Qty])/vBronzePKG, '#,###.')
Try this
=Num(Sum(If(pkgNME='Bronze', [Net Sold Qty]))/vBronzePKG),'#,###.')
Better yet, try this
=Num(Sum({<pkgNME = {'Bronze'}>} [Net Sold Qty])/vBronzePKG),'#,###.')
Both of these give a result of 'Garbage after the expression: ","
My bad, try this
=Num(Sum({<pkgNME = {'Bronze'}>} [Net Sold Qty])/vBronzePKG, '#,###.')
or this
=Num(Sum(If(pkgNME='Bronze', [Net Sold Qty]))/vBronzePKG,'#,###.')
Thank you for your help.