Skip to Content
0
Former Member
Feb 16, 2009 at 11:41 PM

Counting occurences

12 Views

Hello Experts,

I have the following query related to counting occurences of a particular characteristic related to the Calendar month

1) When I choose the option "Average of all values" within exception aggregation for the calculated keyfigure that I am using for the count, it counts all the values including duplicates .i.e. if the charcteristic has repeated occurences for a given month, then it is counted distinct occurence. However, in this case it is not showing me "0" for no occurence but just displaying a blank

2) But when I choose the option "Counting all values" within exception aggregation for the calculated keyfigure that I am using for the count, it does provides me "0" for no occurences but it counts the repeated value as single occurence

How can I get around this? I mean to get repeated values to be counted as separate occurences and also being able to show "0" for no occurence.

Any help will be appreciated

Thanks,

Rishi