Hi Experts,

Thanks for the responses

I got the requireq out put, but when i tired to add zero if no value is defined for a variable,i didnt get the required output

#!/usr/bin/env perl -l

use strict;
use warnings;

use Inline::Files;

my @file_handles = \(*ANIMALS, *FRUITS, *VEGETABLES);
my %data;

for my $fh (@file_handles) {
    while (<$fh>) {
        my ($id, $type, $val1, $val2) = split;
    if ($val1 eq ""){
    $val1 = "0.00";
    }
        $data{in}{$type}{$id}{val1} += sprintf "%.2f", $val1;
        $data{in}{$type}{$id}{val2} += sprintf "%.2f", $val2;
        $data{subtotal}{$type}{val1} += sprintf "%.2f", $val1; 
        $data{subtotal}{$type}{val2} += sprintf "%.2f", $val2; 
        $data{total}{val1} += $val1; 
        $data{total}{val2} += $val2;
    }
} 

for my $type (sort keys %{$data{in}}) {
    print $type;
    for (sort keys %{$data{in}{$type}}) {
        print join("\t" => $_, @{$data{in}{$type}{$_}}{qw{val1 val2}})
+;
    }
    print join("\t" => 'Sub', @{$data{subtotal}{$type}}{qw{val1 val2}}
+);
}
print join("\t" => 'Tot', @{$data{total}}{qw{val1 val2}});
[download]

Output

RACK
A       0       0
B       0       0
C       0       0
D       0       0
Sub     0       0
TACK
E       0       0
F       0       0
G       0       0
H       0       0
Sub     0       0
Tot     0      00
[download]

please guide me where i went wrong

Thanks

---

---

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! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

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:
	&		&
	<		&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.