Calculating Median in Cognos Impromptu

[Swathi37]

Hi All,

There is no median function in cognos. How to calculate median for total hours.
For ex:
This is the data
Internal Service Minutes
I BPP 250
I BPP 120
T BPP 20
I BPP 320
T BPP 420
T BPP 20
T PP 100
I PP 80
T PP 180
T PP 280
I PP 180
I PP 480

I need to find the median in the following format.
Service Internal Median
----------------------------------
BPP I <median>
BPP T <median>
PP I <median>
PP T <median>

I refered knowledge base, it doesn't seem to help me when I have to group by Service and Internal columns. Is it possible to calculate median? Your help is greatly appreciated.
Thank you so much


Swathi

 

[GJParker]

Have you tried using Document#:72236 on the cognos KB

Gary Parker
Systems Support Analyst
Manchester, England

 

[Swathi37]

Gary,
I tried the same logic. The logic works fine if I use Service and internal columns in the filter. If I calculate by grouping them, it gives me zero. Please advice.

Swathi

 

[sharatkb]

Hi Swathi,

Did you try using 'for' in the running-total calculation?
I think if you compute running-total for Service,Internal then it should give the output as expected.

Hope this helps...

Regards,
Sharat

 

[Swathi37]

Thank you Sharat. I will try and let you know.