Subject Re: [firebird-support] COMPUTE
Author Yosvany Llerena Rodríguez
All Alan
I need resume the import by clients and AVG as sales average for Salesmans.
> > salesman clie import
> > ----------- ----------- ---------------------
> > 101 2101 1458.0000
> > sum
> > ---------------------
> > 1458.0000
> >
> > salesman clie import
> > ----------- ----------- ---------------------
> > 101 2102 3978.0000
> > sum
> > ---------------------
> > 3978.0000
> >
> > salesman clie import
> > ----------- ----------- ---------------------
> > 101 2108 150.0000
> > sum
> > ---------------------
> > 150.0000
> >
> > salesman clie import
> > ----------- ----------- ---------------------
> > 101 2113 22500.0000
> > sum
> > ---------------------
> > 22500.0000
> >
> > sum avg
> > --------------------- ---------------------
> > 28086.0000 7021.5000
> >
> >
> > salesman clie import
> > ----------- ----------- ---------------------
> > 102 2106 1896.0000
> > 102 2106 2130.0000
> > sum
> > ---------------------
> > 4026.0000
> >
> > salesman clie import
> > ----------- ----------- ---------------------
> > 102 2114 15000.0000
> > sum
> > ---------------------
> > 15000.0000
> >
> > salesman clie import
> > ----------- ----------- ---------------------
> > 102 2120 3750.0000
> > sum
> > ---------------------
> > 3750.0000
> >
> > sum avg
> > --------------------- ---------------------
> > 22776.0000 5694.0000
> >
> > Best Regards...
> > Yerena
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>