Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am attempting to use set analysis to indentify customers who have orders in two specfic statuses. I know how to make status one or another. I would like to make the set only include those that have "delayed" and "pending" order statuses (multiple orders). Is there a way I can do this?
Here is what I have so far....
Count({$<Status={"delayed","pending"}>}Distinct Customer_id)
Thanks,
Jeff
Try
=count({$<Customer_id = p({<Status={delayed}>})*p({<Status = {pending}>}) >} distinct Customer_id)
Also try this
Count({$<Status={"delayed"}>*$<Status={"pending"}>}Distinct Customer_id)