only count rows with a attribute, which has a timestamp

[Applicable88]

Hello,

I only want to count 

count(distinct{$<Workplace={'5489'},Systemstatus={"*Open*"}>-<[InboundDate]={"*"}>}Orders)

I basically counting all the orders with these attributes, but exclude those which already have a inbound date. But I always get null values. When I take the last part with the exclusion function out, i have values again. It worked before, so I think the database changed. 

I chosed one of the "Exclusion methods":

eg: Field -= A

eg. {A} -{B}

Is there another way to only count those ordernumbers, but only those who has no inboundDate yet. I think the problem lies here, that it cannot figure out if a empty inbounddate is a null, 0 , -   or just empty value. i tried also nullcount and isnull function like this: 

count(distinct{$<Workplace={'5489'},Systemstatus={"*Open*"}, [InboundDate]={"nullcount(Inbounddate)=1"}>}Orders)

or

count(distinct{$<Workplace={'5489'},Systemstatus={"*Open*"}, [InboundDate]-={"*"}>}Orders)

I hope someone knows an answer.

Thanks.

Best. 

[GaryGiles · Accepted solution]

@Applicable88 

You may want to try the E() exclude function:

count(distinct{$<Workplace={'5489'},Systemstatus={"*Open*"},Orders=E({<[InboundDate]={"*"}>})>} Orders)

This should work if you have null values in [InboundDate] when an inbound date has not been set.  You may want to confirm if that is the case.