Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

Set Analysis when Date is given, then count

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. 

 

1 Reply
GaryGiles
Specialist
Specialist

Dates are interpreted differently in set analysis than in an if statement.  Try this:

count({1<[DeliveryDate]={">$(=Date(0))"}>}distinct DeliveryNumber)