Using Max, Aggr, and Count together

[scott_brown]

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

[sunny_talwar · Accepted solution]

How about this

=Count(DISTINCT {<[PO#] = {"=Max(Aggr(Count(DISTINCT EDI_UPC), PO#, EDI_CARTON_NUMBER)) = 1"}>} [PO#])