Community login and other support tools will be unavailable Saturday May 3rd 9:00 am to 3:00 pm (EST) due to planned maintenance. Learn More
Looking for a computation for the IBPL attribute for the multivalued.
Variant IBPL is a IBPL attribute,
Example IBPL pick values are RED, GREEN, BLACK etc
REQ 1 -- RED
REQ 2 -- RED, GREEN
REQ 3 -- RED, GREEN
REQ 4 -- BLACK
How to find the Req's count having IBPL values RED;GREEN. IBPL types are in the Playground project, I used to follow below computation but its not working for multiple values.
aggregate("Contains", ByDocument(false, false), sum((Category="Requirement" and "Variant IBPL"=="RED:/Playground;GREEN:/Playground")?1:0))