9 Replies Latest reply: Jan 24, 2014 9:19 AM by Paul Yeo RSS

    I need to count how many items with out any unit price

      Hi All

       

       

      I need to count how many items with out any unit price.

       

       

      Below expression working fine , which can count how many items ?

      count(distinct(PART_NO_))

       

       

      In order to count only those items have unit price , i need add the above condiction into above expression :-

      count(if([Unit Price] > 0), distinct(PART_NO_))

       

       

      But it cannot work.

       

       

      Can some one advise me ?

       

       

       

       

      Paul