hi,
i am trying to use median in my report. what is happening is, if use median in more than one column. It shows same values in both columns.
example:
Col1 Col2
A 5 6
B 6 7
C 7 8
D 8 9
E 9 10
expected result is :
Median 7 8
But it is showing
Median 7 7
I noticed one more thing, if i switch columns i mean Col2 first and then Col1
the result is
Median 8 8
pls advice
thanks
log a case with Cognos. sounds like a bug to me.