topic Re: COUNT DISTINCT NULL in left Join Table in App Development

COUNT DISTINCT NULL in left Join Table

trishmre — Tue, 29 Mar 2022 05:40:12 GMT

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.

justISO — Tue, 29 Mar 2022 06:15:55 GMT

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))

trishmre — Tue, 29 Mar 2022 06:34:40 GMT

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.

justISO — Tue, 29 Mar 2022 06:44:15 GMT

Maybe this way:

count(distinct if ((len(PO)=0 or isnull(PO)) and [PR Status]='Open', PO))

trishmre — Tue, 29 Mar 2022 06:53:52 GMT

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'

RsQK — Tue, 29 Mar 2022 12:45:29 GMT

Hi, this?

=COUNT({<PR*=E({<PO={"*"}>}),[PR Status]={'Open'}>}DISTINCT PR)

trishmre — Tue, 29 Mar 2022 23:48:06 GMT

It works! thank you. I appreciate your help.