Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
You are right Aleksei. I added this default set's intersection with SupplierHasContract selection. So, here it is:
Count({(<Supplier=P({<SupplierHasContract={"Missing","Expired"}>} Supplier)*P({<SupplierHasContract={"Active"}>} Supplier),SupplierHasContract={"Active"}>
+<Supplier-=P({<SupplierHasContract={"Missing","Expired"}>} Supplier)*P({<SupplierHasContract={"Active"}>} Supplier)>)*<SupplierHasContract=P(SupplierHasContract)>}
DISTINCT Supplier)
Hello Aleksei,
You can do it with set expression as this:
Count({<Supplier=P({<SupplierHasContract={"Missing","Expired"}>} Supplier)*P({<SupplierHasContract={"Active"}>} Supplier),SupplierHasContract={"Active"}>
+<Supplier-=P({<SupplierHasContract={"Missing","Expired"}>} Supplier)*P({<SupplierHasContract={"Active"}>} Supplier)>}
DISTINCT Supplier)
Regards,
Thank you! This seems to work with a default view. However, when I filter by "Missing" or "Excluded" it still shows active contracts (see screenshot attached). Any idea how to get rid of them?
Regards,
Aleksei
You are right Aleksei. I added this default set's intersection with SupplierHasContract selection. So, here it is:
Count({(<Supplier=P({<SupplierHasContract={"Missing","Expired"}>} Supplier)*P({<SupplierHasContract={"Active"}>} Supplier),SupplierHasContract={"Active"}>
+<Supplier-=P({<SupplierHasContract={"Missing","Expired"}>} Supplier)*P({<SupplierHasContract={"Active"}>} Supplier)>)*<SupplierHasContract=P(SupplierHasContract)>}
DISTINCT Supplier)
Yep, this fixed it. Thanks a lot for your help!