only count rows with a attribute, which has a timestamp

Applicable88 — Fri, 12 Feb 2021 20:08:38 GMT

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)

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

I hope someone knows an answer.

Thanks.

Best.

Re: only count rows with a attribute, which has a timestamp

GaryGiles — Fri, 12 Feb 2021 20:58:37 GMT

@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.

topic Re: only count rows with a attribute, which has a timestamp in App Development

only count rows with a attribute, which has a timestamp

Re: only count rows with a attribute, which has a timestamp