Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I count distinct Open PR for PO Creation?
I have tried the count distinct and isnull PO. But till incorrect count.
This is left join table.
Hi, this?
=COUNT({<PR*=E({<PO={"*"}>}),[PR Status]={'Open'}>}DISTINCT PR)
Hi, not sure where you want to count this, in load script or report level, but as one of suggestion could be something like this:
count(distinct if (len(PO)>0, PO))
Hi
I am trying to have KPI chart, I need to count the NULL PO or PO = '-' that has PR Status equal to Open and distinct the PR.
Maybe this way:
count(distinct if ((len(PO)=0 or isnull(PO)) and [PR Status]='Open', PO))
Not working, I am expecting to have number of PO.
I have already count of Open PR
=Count(distinct{<[PR Status]= {'Open'}>}PR)
I need to add condition to count the null PO for the Distinct PR column that has PR Status = 'Open'
Hi, this?
=COUNT({<PR*=E({<PO={"*"}>}),[PR Status]={'Open'}>}DISTINCT PR)
It works! thank you. I appreciate your help.