I have 10 requirements in a document having short text field with various values
"free text" is a name of field which is of short text type and available on Requirement Type
Ex. there are 5 RQ's are having free text value is Black,
Que: How to count the REQ's which are with Black value free text ? the count is needed on Report's computation.
REQ 1 --> free text = Black
REQ 2 --> free text = Black
REQ 3 --> free text = Green
REQ 4 --> free text = Yellow
REQ 5 --> free text = Red
REQ 6 --> free text = Black
REQ 7 --> free text = Black
REQ 8 --> free text = Pink
REQ 9 --> free text = Green
REQ 10 --> free text = Black
I tried with some aggregate functions,
Count of Req's having free text value --> possible, But how to count with specific text ?
aggregate("Contains", ByDocument(false, false), sum((Category="Functional Requirement" and SelectionCount("free text")!=0)?1:0))
IsEmpty(aggregateByTree("Contains", References,sum(Category == "Functional Requirement" and "free text" == "Black" ? 1 : 0)), 0)
Or if that doesn't works:-
- Refer Help Material "Computed Expression Function Classes" page, there you will see all possible computation.
Does this help?
Vielen Dank / Many Thanks
The provided workaround IsEmpty(aggregateByTree("Contains", References,sum(Category == "Functional Requirement" and "free text" == "Black" ? 1 : 0)), 0) is not working.
Also as i checked in the manual "Computed Expression Function Classes" we cannot get anything for text value attribute.