If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

D list Average Calc

Started by lanalana, 13 Aug 2011 12:08:21 PM

Previous topic - Next topic

lanalana

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

jeffowentn

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