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

Median Calculation in AS

Started by janspops, 30 Nov 2007 09:49:32 AM

Previous topic - Next topic

janspops

When creating a Median calculation in Analysis Studio (AS), you're asked to provide a number in the expression, eg: Median(item,number).  Does anyone know what the number in the expression represents?

MFGF

Hi,

It's just a way of allowing you to manually code one of the values used in the calculation.  When you are creating the calculation, you can select the relevant items in your set, and optionally you can also type in a number to be used.  So for example, if you have your Years as columns and define a Median calculation for this set, you can select two or more Year values to give you a calculation - median(2005,2006) - which returns the median measure values for these two years, and/or you can enter a number into the dialog - median(2005,15) - which gives you the median of the 2005 measure values and 15.

Regards,

MF.
Meep!

janspops

Thanks... I'll give it a try. / JP