If I understand your objective correctly, I don't think you've picked a good approach for your data structures. You're storing your detail information in @fields, but there is no good way to link your totals back to the details!

Given the apparent nature of your data - data sets linked together by a common field - I'd think a hash is the way to go. A hash of arrays (HoA), where each hash entry corresponds to a company, and each array entry is a set of transaction details(?). Instead of just keeping totals in a hash (as you're doing with %sumcredits), keep it all in there!

Something like this (untested): 

my %details_for = ();
for (... [your loop beginning here] ...){
   my $trans_details = $details_for{$comp_ident};
   unless ($trans_details){
      $trans_details = [];   # first time for this company.
                             # create its array of details.
      $details_for{$comp_ident} = $trans_details;
   }

   # Add to array of trans details for this company
   push @$trans_details,
      { company_ident => $comp_ident,
        company       => $company,
        ... etc.,
        debits        => $debits,
        credits       => $credits
      };
}

# Ok, now you've accumulated the data
print STDERR Dumper(\%details_for);   # just for debugging.

# Print the results:
foreach my $comp_ident (keys %details_for){
   my @trans_details = @{$details_for{$comp_ident}};
   my $comp = $trans_details[0]->{'company'};
   my $sumcredits += $_->{'credits'} for (@trans_details);

   # Show the total credits
   print $comp, "\t", $sumcredits, "\n";
   foreach my $trans(@trans_details){
      print " " x 3;   # indent a little
      print "effective: ", $trans->{'effective_date'};
      print ". created: ", $trans->{'date_created'};
      # etc.
      print "\n";
   }
}

[download]

This is how I'd approach it. If you want to stick with using an array to keep your transaction details, you could... but you'd have to loop over the entire array to find the transactions for the company you want to print details on, probably with grep: 

foreach $comp (keys %sumcredits) {
   print $comp . "\t" . $sumcredits{$comp} . "\n";

   my @trans_details = grep {$_->{'company'} eq $comp} @fields;
   # Now loop over @trans_details and print.
};

[download]
Depending on the size of your data, I wouldn't really recommend this approach. Conceptually, your data is a HoA (as near as I can tell), so you should represent it as such in Perl.

Hope this helps. And, all code above is completely untested and probably littered with typos.

In reply to Re: Query Array from Hash by crashtest
in thread Query Array from Hash by drodinthe559

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.