Summary of Summaries

Question

I have an application that has a work group intake table [Parent]. From that workflow intake, it can be assigned to multiple work groups [Child]. And then can be assigned to multiple individuals [Child of Child]. I have created multiple summary fields from the work group records to the work group intake table. I now want to aggregate the multiple summary fields into another field. I know I can use the "ToText" function to summarize the fields, but it then leaves the semi colon delimited. That's not visually appealing. I want something like:

Summary field 1 - [Summary field 1]
Summary field 2 - [Summary field 2]
Etc.

I can't figure out how to code it so it appears nice like that. Any help is welcome.

------------------------------
MICHAEL SARGENT
------------------------------

Summary field 1 - [Summary field 1]
Summary field 2 - [Summary field 2]
Etc.

I can't figure out how to code it so it appears nice like that.&nbsp; Any help is welcome.------------------------------MICHAEL SARGENT------------------------------

markshnier__you · Answer

Can you post a screen show of your combined text summary field and what you want the result to be?

I'm not understanding the b old part

Summary field 1 - [Summary field 1]

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

michaelsargent · Answer

Hey Mark,&nbsp; so you can see that I have multiple Current Status Summary fields.&nbsp; What I want to do is create a field that summarizes all this into one.&nbsp; But, i want it to appear where it would look like:"POS Summary:" (This would be text) - [Current Status Summary POS]"NTW Infrastructure Current Status Summary" - [Current Status Summary - NTW Infrastructure]the problem i'm having it errors out when I try to create a multi-line approach.&nbsp; Would i need a list function or how do I accomplish this?------------------------------MICHAEL SARGENT------------------------------

paulpeterson1 · Answer

You could use something like this:List("
", "Summary Text 1:&nbsp; " &amp; [Field 1], "Summary Text 2:&nbsp; " &amp; [Field 2], ...)&nbsp;and if you only want fields that have a value:List("
", If([Field 1] != "", "Summary Text 1:&nbsp; " &amp; [Field 1]), If([Field 2 != "", "Summary Text 2:&nbsp; " &amp; [Field 2]), ...)------------------------------Paul Peterson------------------------------

Forum Discussion

Summary of Summaries

3 Replies