6 Replies Latest reply: Jun 8, 2017 3:24 AM by Ruan Greeff RSS

    multiple supplier expression

    naveen kumar

      Hello,

                i want to display count of products  which is supplied by only  one supplier

                                                          

      load * inline

      [

      product,supplier

      A,XXX

      A,YYY

      A,ZZZ

      B,HHH

      B,LLL

      C,OOO

      L,PPP

      ];

      expression:   =Count(Aggr(If(Count( distinct supplier) = 1,supplier),product))    so answer:2 which is correct

      now for the same data i am trying to count  products which is supplied by multiple supplier

      expression:     =Count(Aggr(If(Count( distinct supplier) >1,supplier),product))  so answer suppose to be 2 but i am geeting zero

       

      can any help plz.

       

      Thanks