Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Having trouble with the following expression.
=count(distinct if(max(aggr(count(distinct EDI_UPC),PO#,EDI_CARTON_NUMBER))=1,PO#))
I'm attempting to count the number of PO#'s that have a maximum of 1 EDI_UPC in any EDI_CARTON_NUMBER.
This portion of the expression is working fine:
=max(aggr(count(distinct EDI_UPC),PO#,EDI_CARTON_NUMBER))
How about this
=Count(DISTINCT {<[PO#] = {"=Max(Aggr(Count(DISTINCT EDI_UPC), PO#, EDI_CARTON_NUMBER)) = 1"}>} [PO#])
How about this
=Count(DISTINCT {<[PO#] = {"=Max(Aggr(Count(DISTINCT EDI_UPC), PO#, EDI_CARTON_NUMBER)) = 1"}>} [PO#])