Decimal dimension isn't collapsing in a chart object

[#1]

My dimension is formed with

NUM(NGR,'###########,###.00') AS NGR_DEC2

My expression is

COUNT(PRIMARY_KEY)

The problem is that it's not collapsing NGR_DEC2 (group by).  See screenshot.

[Nicole-Smith · Accepted solution]

You probably want to use round() instead:

round(NGR, .01) AS NGR_DEC2