Min, Max Value

Mon, 08 Oct 2012 23:15:32 GMT

Hello All,

I have a requirement where i need to shaow Min/Max/Avg values

Client Rev

1 100

2 50

3 75

4 25

5 -50

6 -25

The O/P should be

Max: 100

Min: -50

Avg: 29 (For Avg the client can vary)

i was able to achieve max using the below as dimension and then hiding the dimension in the presentation.

aggr(rank(sum(Net)),Client

)

is there ay other way that i can use .

Thanks

Re: Min, Max Value

Tue, 09 Oct 2012 01:14:42 GMT

HI,

You could try this.

Average - num(avg(Rev),'##')

Min - num(min(Rev),'###')

Max - num(max(Rev),'###')

Regards,

Janzen