Forum Discussion

Qrew Cadet

2 years ago

Separate out multiselect text field items in a summary report

Hello. I have a multiselect text field 'Construction Plan - ASMT' with 6 values. I need to create a summary report to count the Construction Plan and the status it is in. Screen shot below. ...

MarkShnier__You

Qrew Legend

2 years ago

I think that you should create 6 fields like this example for [Network Drop Count]

If(Contains(ToText([Construction Plan - ASMT]),"Network Drop"), 1,0)

Then drop that first group by off the Summary report (Construction Plan - ASMT) and change the report to "summarize what" to be each of the 6 fields.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------