my $total_value = 0;
foreach my $result (@{$testsub->result()}) {
   foreach my $column (@{$result->{columns}}) {
      $total_value += $column->{test1};
   }
}