in reply to Re^2: Refer calculated fields
in thread Refer calculated fields

No - with (pure) Perl, you will have to calculate such stuff yourself.

What you can do is map your Array of Hashes to a DBD::SQLite table, backed by your Perl data structure and then just use SQL to query your Perl data structures:

use DBI; use DBD::SQLite; # ... sub import_data( $self, $book ) { my $dbh = DBI->connect('dbi:SQLite:dbname=:memory:',undef,undef,{A +utoCommit => 1, RaiseError => 1,PrintError => 0}); $dbh->sqlite_create_module(perl => "DBD::SQLite::VirtualTable::Per +lData"); my $sql_name = "mytable"; my $colnames = join ", ", qw(PvcCount LCir RCir); local $table_000 = \@data; my $tablevar = __PACKAGE__ . '::table_000'; my $sql = qq(CREATE VIRTUAL TABLE temp."$sql_name" USING perl($col +names, arrayrefs="$tablevar");); $dbh->do($sql); my $sum = $dbh->selectall_arrayref(<<'SQL'); select sum( PvcCount ) , sum(LCir) , sum(RCir) , EquipName from mytable group by EquipName SQL