How do I create this summary based on a multi-select text field?

Question

I have a multi-select field and I'm trying to get a specific summary report and can't figure this out.

For my FIELD I have the following text options:

Option 1
Option 2

Let's say I have the following:

FIELD1 | FIELD2 | FIELD3 | FIELD4

Option1 | Option1 | Option2 | Option 2

blank | Option2 | blank | blank

The current summary is:

Option1 = 1
Option2 =2
Option1;Option2 = 1

But what I want is:

Option1 = 2
Option2 = 3

How can I get this summary? Appreciate any help!

quickbasecoachd · Answer

I think you would nee to have a formula numeric field per Choice.

The field called [Option 1] would be like

var text ChoicesInText = ToText([Field]);

If(Contains($ChoicesInText, "Option 1"),1,0)

Same for Option 2

Then run your report to Total each of the [Option x] fields.

zoegluck · Answer

To run a report with these fields, do you have to run a separate report for each field? If not, how can you configure the report to summarize this?

Forum Discussion

How do I create this summary based on a multi-select text field?

Related Content

If Then Else formula with a multi select field.

Checkbox Fields Vs Multi-Select Fields for Tracking

Summary report w/multi-select field

Using multi select field in pipelines

Summary Reports