Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.