AnsweredAssumed Answered

Exporting Sub-summary Sorted Totals, Totals entire total in Found Set

Question asked by jakrissmittant on Jan 20, 2016
Latest reply on Jan 25, 2016 by jakrissmittant

First of all let me apologize in advance for any improper use of lingo for what I'm about to ask below, as I am an amateur with FMP trying to debug an existing database.

 

I have a database that has a number of records with fields and calculations and summaries.  For the purpose of this discussion, let's say I have a records list of video sequences, each with their own acronyms.  ie.  Sequence "ABC," "DEF," etc... Within those records I have a calculation totaling specific fields.  From there I have a sorting button which sorts/groups each sequence of an extended found set, then adds a Sub-summary with a total from the records from that specific sequence.

 

Here's a crude representation, sorry I can't screengrab due to privacy issues:

 

Sequences

 

ABC

     Record 1. $100

     Record 2. $200

     Record 3. $300

                              Total: $600          (Sub-summary)

 

DEF

     Record 1. $400

     Record 2. $500

     Record 3. $600

                              Total: $1500          (Sub-summary)

 

 

This information is displayed after doing a Find for "ABC," then another find with Extend Found Set for "DEF."

The data totals sorts and totals correctly in this view.  Great.

 

The problem I'm having comes on the export to Excel.  Instead of exporting the column total as displayed above with the separated sequences, it's combining the two sequence totals.  ie.  $2100.  I want it to export ABC's total column as $600 and then list DEF as $1500 on it's rows. 

 

Again, apologies if that is too vague and if anyone is unable to decipher what I'm trying to accomplish.

Thanks for your help.

Outcomes