Forum Discussion
JohannaEvans
Qrew Trainee
I have a list of multi text selections that have about 25 items.
When I summarize the fields, a table displays the selections by grouping:
Item 1 = 1
Item 1, 5 = 1
Item 1, 3 = 1
This is not what I am looking for, therefore, I thought I could write a formula that recognized the group rather than the grouping.
Item 1 = 3
Item 3 = 1
Item 5 = 1
JohannaEvans
6 years agoQrew Trainee
var text Selections = ToText([Linked to Priority Strategic Aim]);
var text SearchTerm = "PC 1.0 Readmission rate";
IF(Contains($Selections, $SearchTerm),1,0)
Formula error
The field is text but the formula returns a number result.