4 Replies Latest reply: May 15, 2014 9:59 AM by cardealers _ RSS

    Summary - Key Fields

    cardealers _

      I am combining two reports in a one to many entry format.  The end reports looks like:

      [LIST

      MANAWA 4849.53 0.00 0.00 MANAWA  77 DAVE   2425.87

      -


      MANAWA 364 DENNIS 2423.66

      ARCHER 3555.18 0.00 0.00 ARCHER  77 DAVE   1777.59

      /LIST

      (the dashing are just to get the report to look correct)

       

      In order to get get this output I have created the following summary:

      /size[list][*]Filter:     Default Filter

       

      Key fields:     Account, Dealer, Overfund Fees, Other 3, Other 4, Total

       

      Item fields:     Dealer #, Dealer Name, Agent Number, Agent Name, Amount

       

      Summary fields:[/size][/list]The fields Overfund Fees, Other 3, Other 4, Total, Amount are all numeric, but when I export the summary to Excel these fields are character.

       

      Any ideas how to get the numeric fields to stay numeric?  I know it has to do with the way I built the summary, but I haven't figured out how to get my report in any other way.