Discussions

 View Only
Expand all | Collapse all

Separate out multiselect text field items in a summary report

  • 1.  Separate out multiselect text field items in a summary report

    Posted 06-02-2023 15:29

    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. 

    Without creating a child table for this field, can i create a summary report where the textlist field items are separated out? Today we are doing this in Access.

    Thank you.



    ------------------------------
    Uma Harithsa
    ------------------------------


  • 2.  RE: Separate out multiselect text field items in a summary report

    Posted 06-02-2023 16:29

    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
    ------------------------------