Count of Distinct Records

[#1]

Dear Experts,

Kindly help me regarding the Following

PO No	PR NO	RFQ NO	Expression
10	101	1011	4000
20	201	2011	3000
30	301		2000
40		3011	5000

I am having a Pivot Table of the above type

I am making another Chart in which I am counting No.POs, No of PRs and No of RFQs

I am using following script =count (distinct (FIELD NAME)),

Result should be PO = 4 PR = 3 RFQ  = 3

BUT I am getting result PO= 4 PR = 4 RFQ = 4

I think it is counting the blank field also

Kindly help on this

Thanks and Regards,

Animesh

[nilesh_gangurde]

Hi Animesh,

Please attach the sample data with qvw file

Regards,

Nilesh Gangurde

[#3 · Accepted solution]

Hi animesh_5,

yes, blank will be counted as a value but null will not be counted. So, if there is a blank then you can force null.

Which will give you correct results.

Please find the attached app.

Let me know if any issue.

..

Ashutosh

[#4]

Dear Ashutosh,

I was having a lot problem with this perticular Issue, it is solved with your help !!!!

Thanks a lot Sir.