count distinct calculation

[timmy]

Hey,

How can i make something like this?(this is wrong, i know but i need only the shipdate-duedate for the distinct orderid)

=count(Distinct OrderID if((ShipDate-DueDate)<=0,1))

TNX

Timmy

[#2]

Hi

I haven't tested this so apologies if my guess is completely wrong, could you try:

=Count ( Distinct ( If ( ShipDate - DueDate <= 0 , OrderId ) ) )

Regards,