11 Replies Latest reply: Jun 29, 2017 11:30 AM by Pankaj Thakur RSS

    how to write expression

    naveen kumar

      Hi all,

       

      i need to show only those plant and suppliers whose terms are more then 1

      plant      supplier         terms( expression i wrote is  count distinct terms)

      xxx          aaa                  4

      yyy            bbb                  3

      zzz           ccc                     2

      kkk           ddd                    1

      hhh           eee                    1

       

      but what i need to display is only those terms >1

       

      plant      supplier         terms

      xxx          aaa                  4

      yyy            bbb                  3

      zzz           ccc                     2

       

      how to achieve this plz

       

      thanks