Problem in Count

[#1]

Dear Experts,

I am encountering Problem in Count Function

I have the Following Fields

Field Name	Description
Werks	Plant
EBELN	PO NO
BANFN	PR NO
ANFNR	RFQ NO
EKORG	Purchase ORG

I am trying to count the NO. PO's which are made without Referencing PR and NO of POs made without Referencing RFQ

and then I will find out % Non Complaince (PR) =( NO. of PO without PR)/ (Total No of PO) and similarly for RFQ

In Expression I am restricting using following code "=count({<EKORG = {'serv'}>}distinct EBELN)" this is working

but when I am using "=count({<EKORG = {'serv'}>}{<BANFN = {' '}>}distinct EBELN)" it is not working

I am attaching the excel with the Example and Desired Result.

Your Help will be highly appreciated

Thanks and Regards,

Animesh

[chematos]

try this:

count({<EKORG = {'serv'}, BANFN = {' '}>}distinct EBELN)

Regards

[#3 · Accepted solution]

In my Query I had mentioned the Code which I had used in the expression

"=count({<EKORG = {'serv'}>}{<BANFN = {' '}>}distinct EBELN)"

for this to work I had to pass the Null Value and therefore I had to use the following code while loading the data from .QVD File

If( Len( Trim( ANFNR ) ) > 0, ANFNR, '$(NullValue)' ) as ANFNR

If( Len( Trim( BANFN ) ) > 0, BANFN, '$(NullValue)' ) as BANFN

after using this the Results started coming correctly.

With regards,

Animesh