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?
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.
Thanks... I'll give it a try. / JP