Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have several DeliveryNumbers tables linked to each other.
One Table is only for inbound and one for outbound.
I want a KPI Window which count the deliveries which are already send out and if there is no DeliveryDate it means its still there. So I tried several combinations which always give me ZERO:
count({1<[DeliveryDate]-={"0"}>}distinct DeliveryNumber)
count({1<[DeliveryDate]={">0"}>}distinct DeliveryNumber)
Only a simple If-Statement seems to work:
If(DeliveryDate>0, DeliveryNumber)
But thats only for the table not for the KPI Window.
I just wanted to know why it doesn't work with Set Analysis.
Thank you.
Best.
Dates are interpreted differently in set analysis than in an if statement. Try this:
count({1<[DeliveryDate]={">$(=Date(0))"}>}distinct DeliveryNumber)