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

  • 1
  • 2
  • Question
  • Updated 2 months ago
  • Answered

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!

Photo of Grace

Grace

  • 20 Points

Posted 3 years ago

  • 1
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,670 Points 50k badge 2x thumb
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.
Photo of Zoe Gluck

Zoe Gluck

  • 60 Points
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?