| Question about COUNT vs COUNTDISTINCT [message #794066] |
Wed, 08 February 2012 17:11  |
Eclipse User |
|
|
|
Hi,
Please have a look at my report design in attachment. If I use COUNT as the function in aggregation, the value is 1; however, if I use COUNTDISTINCT as the function, the value is 0. I might understand it wrong but I thought COUNTDISTINCT should return 0 as well. Please advise. (I'm using 2.6.2)
Neil
|
|
|
| Re: Question about COUNT vs COUNTDISTINCT [message #794090 is a reply to message #794066] |
Wed, 08 February 2012 17:41  |
| Eclipse User |
|
|
|
Neil,
This may be a bug. If you add the following filter:
row["STATE"] == "CA" && dataSetRow["COUNTRY"] == "UK"
and put the expression in as:
dataSetRow["STATE"]
It should work.
Jason
On 2/8/2012 5:11 PM, Neil Wang wrote:
> Hi,
>
> Please have a look at my report design in attachment. If I use COUNT as the function in aggregation, the value is 1; however, if I use COUNTDISTINCT as the function, the value is 0. I might understand it wrong but I thought COUNTDISTINCT should return 0 as well. Please advise. (I'm using 2.6.2)
>
> Neil
|
|
|
Powered by
FUDForum. Page generated in 0.03200 seconds
Home