Average for (Week, Month and Year)

[tmumaw]

Trying to figure out how to get some averages using the attached file.  I need an average for the Profit Center by FISYR, FISPD and WEDAT.  Would like to do this in the script if possible.

Thanks

[sunny_talwar · Accepted solution]

May be like this:

LOAD [Profit Center],

           WEDAT,

           FISYR,

           FISPD,

           Avg(NoEmp) as AvgNoEmp

Resident ....

Group By

           [Profit Center],

           WEDAT,

           FISYR,

           FISPD;

[tmumaw]

Thanks Sunny......