Summary formula for Multi-Select Text
Hello, I am trying to create a summary report for selections made in a multi-select field. I'm using the formula -
IF(Contains($Selections, $SearchTerm),1,0) and am getting the error -
F...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIs the result of your formula supposed to be the number of selections? Can you give an example of what your day looks like and the response that you expect?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
HI Mark,
Yes, the result will total the number of selections. We would like metrics to display how many collaboration attempts resulted in a successful transfer to a nurse ("A1A Nurse Care Manager- Successful") and how many resulted in a referral due to no nurse being available to take the transfer ("A1A Nurse Care Manager- Nurse not available; referral sent").
I hope that helps?
------------------------------
Christie Anderson, PMP She.Her.Hers. | Proactive Care Management Associate, Aetna One Advocate
p 959-230-7059
6005 Nacot Pl, Mail Code F488, New Albany, OH, 43054
------------------------------
Yes, the result will total the number of selections. We would like metrics to display how many collaboration attempts resulted in a successful transfer to a nurse ("A1A Nurse Care Manager- Successful") and how many resulted in a referral due to no nurse being available to take the transfer ("A1A Nurse Care Manager- Nurse not available; referral sent").
I hope that helps?
------------------------------
Christie Anderson, PMP She.Her.Hers. | Proactive Care Management Associate, Aetna One Advocate
p 959-230-7059
6005 Nacot Pl, Mail Code F488, New Albany, OH, 43054
------------------------------