2 Replies Latest reply: Jan 20, 2015 4:12 AM by rajiv krishna RSS

    Wrong count totals ?

      Hi all,

      I have a simple table showing a count of work activities by type (down) and month (across). The expression is simply: count(distinct activity). I am using distinct because for each day there are two records, morning activity and afternoon activity, but I am not interested in this split to be shown in this table.

      The issue is that if I add totals they are wrong. What i am looking for is just the sum of the row values (counts), but the totals are different.

      Any clue ? how can I get the right totals ? I have noticed that in object Properties totalization rules are grayed when the expression is a count, I don't understand why.

      Thanks for helping.

      Nik

       

      I am using Ver. 9