Forum Discussion
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
Test 1
var textlist Selections = ToTextlist([Linked to Priority Strategic Aim]);
var text SearchTerm = "PC 1.0 Readmission rate";
IF(Contains($Selections, $Search Term),1,0)
If (Contains([PC 1.0 Readmission rate],"PC 1.0 Readmission rate"),1,0)
Formula syntax error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
Test 2
var text Selections = ToText([Linked to Priority Strategic Aim]);
var text SearchTerm = "PC 1.0 Readmission rate";
IF(Contains($Selections, $SearchTerm),1,0)
If (Contains([PC 1.0 Readmission rate],"PC 1.0 Readmission rate"),1,0)
Formula syntax error
There are extra characters beyond the end of the formula.
var text Selections = ToText([Linked to Priority Strategic Aim]);
var text SearchTerm = "PC 1.0 Readmission rate";
IF(Contains($Selections, $SearchTerm),1,0)
If (Contains([PC 1.0 Readmission rate],"PC 1.0 Readmission rate"),1,0)