Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 years ago

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

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!

reports and charts
Tables and fields

2 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    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's avatar
    ZoeGluck
    Qrew Member
    6 years ago
    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?