Impromptu and average on modified series of numbers -
09-10-2003
, 06:44 AM
All,
How can I accomplish the following with Cognos Impromptu?
I ectract a series of numbers that I want to calculate the average on.
However before the calculation I want to remove the two smallest
values from the series.
Eg. I extract:
1,2,3,4,5,6 or 1,1,2,2,2,3,4,5,6
Remove the smallest values and calclulate the average on:
3,4,5,6
TIA
Tom |