2 Replies Latest reply: May 8, 2014 9:05 AM by Tanja Varwijk RSS

    Set Analysis question

    Tanja Varwijk

      Why gives these 2 rows not the same answer ?

       

      Count(DISTINCT(if((Quantity<>0 and CYFlag=1 and [Shipping Agent Code]<>'KASSA'),Document_Nr)))

      Count({$<CYFlag={1},[Shipping Agent Code]-={'KASSA'},Quantity-={0}>}DISTINCT(Document_Nr))