Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey All, I am struggling to come up with an expression for a KPI that is being built. The KPI will display how many individual orders are "Past Due" from their due dates. I do not need days past due, but the number of orders that are past due.
As far as data, I have DueDate and OrderID, but do not have a master calendar set up for Date.
Hi @awilson484 , probably it should be something like this:
Count({<DueDate={"<$(Today())"}>} Distinct OrderID)
JG
Hi @awilson484 , probably it should be something like this:
Count({<DueDate={"<$(Today())"}>} Distinct OrderID)
JG