Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Animesh,
Please attach the sample data with qvw file
Regards,
Nilesh Gangurde
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
Dear Ashutosh,
I was having a lot problem with this perticular Issue, it is solved with your help !!!!
Thanks a lot Sir.