Average Calculations

[tmumaw]

Hi all,

I need to be able to calculate averages at different levels using one QVD.  I need averages for WKNO, FISPD, QTR and FISYR for each profit center.  Any ideas?

Thanks

[qlikview979]

Hi ,

can you please share the expected output.

regards

[tmumaw]

Here is what I have:

I use sum(aggr(avg(EmpCt_ZEMPCT),[PC Desc],FISYR))  to get the Avg Employee counts by year.

I use sum(aggr(avg(EmpCt_ZEMPCT),[PC Desc],FISYR,Action))  to get the Avg Employee counts by year. and action.  I'm sort of confused on what this is giving me. 

Thanks