Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Try
Count({$<CYFlag={1},[Shipping Agent Code]-={'KASSA'},Quantity={">0"}>}DISTINCT(Document_Nr))
Quantity can also be negative