Forum Discussion
Thousand separator using COUNT values
hi Anonymous
select the field and click at the red cickle
That works fine wiht SUM, but not COUNT
hi Anonymous,
have you created a measure or are you just pulling in a column to the vaue field? If the latter is the case, then the formatting of the column have no impact. Try creating a measure, number of cases = count(caseID), and format the measure according to you need
The collumn is just pulled in the vaue field. Then i can choose SUM, AVG, COUNT etc.
But the thousind separator is only there, when i choose SUM.
In excel there is no problem.
The work around you suggest is cumbersome in my case.
I think it should be easy to format everything in the value field. Like in excel.
Numbers wiht more than 5 digits can be hard to overlook - the reasion for the separator :-)
