Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Average for (Week, Month and Year)

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

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

LOAD [Profit Center],

           WEDAT,

           FISYR,

           FISPD,

           Avg(NoEmp) as AvgNoEmp

Resident ....

Group By

           [Profit Center],

           WEDAT,

           FISYR,

           FISPD;

View solution in original post

2 Replies
sunny_talwar

May be like this:

LOAD [Profit Center],

           WEDAT,

           FISYR,

           FISPD,

           Avg(NoEmp) as AvgNoEmp

Resident ....

Group By

           [Profit Center],

           WEDAT,

           FISYR,

           FISPD;

tmumaw
Specialist II
Specialist II
Author

Thanks Sunny......