For some reasons, I am using Count(Distinct(ColName)) function for 5 objects in the universe. I tried to use these objects in a report, but I got the error message ’ DISTINCT is specified more than once’. I am on DB2. The syntax for the count function is Count(Distinct()). Can’t I use just count function in the universe without distinct? Any other suggestions ?
Thanks
Ravi.
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Ravi,
You can use count without the distinct, but you should include distinct in your count function, if you really mean to count every distinct row only once.
Make sure that you have ‘Duplicate rows’ chosen in your options box in the query panel, if you want to use a count object with distinct built into it. If your report is set to retrieve no duplicates, your query will automatically have ‘distinct’ included after the Select.
Kurt Kerchner
SBC Communications Inc.
(314)340-9853
Fax#(314)235-4679
Can’t I use just count
function in the universe without distinct? Any other suggestions ?