Print Page - D list Average Calc

Title: D list Average Calc
Post by: lanalana on 13 Aug 2011 12:08:21 PM

Hi

I'm trying to calculate some averages, and I am not sure are there any BiFs for what I would like to do.

For example, i have the following numbers:

Jan: 100
Feb: 200
Mar: 300
Apr: 400
....

I want to calculate averages like: (Jan+Feb)/2, (Feb+Mar)/2....
I can always add an extra Dlist item and use the internal link, but I would like to aviod adding extra items. As far as I know, the only way to calculate this is to have both numbers I want to divide in one column. Or is there any BiF for Average that would do this?

Thanks

Title: Re: D list Average Calc
Post by: jeffowentn on 15 Aug 2011 12:55:50 PM

Try using MovAvg for your BiF calculation. There is info in the Help files regarding the variables.

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: lanalana on 13 Aug 2011 12:08:21 PM