1 Reply Latest reply: Jun 25, 2013 1:07 PM by Gysbert Wassenaar

# Max value of Aggregation

Hi,

I have a chart containing cumulated data using this expression:

=RANGESUM(

ABOVE(

SUM({<

[Measures (Key)]={'Operating Profit (EBIT)'},

[Version single (Key)]={'Actual'},

Period,

[Year period 1]={\$(vTwelveMonthRolling_All)}

>}Values)/1000000

,

0

,

RowNo()

)

)

With this dimension: [Year period 1].

My question is, how to calculate the highest and the lowest value from this chart expression within a simple text-object.

This means if my data looks like this:

 Year period 1 Single values Cumulated values Jan 13 36,1 36,1 Feb 13 4,2 40,3 Mar 13 80,1 120,4 Apr 13 -68,8 51,6 May 13 62,1 113,7 Jun 13 67,3 181 Jul 13 -63,4 117,6 Aug 13 88,1 205,7 Sep 13 -14,7 191 Oct 13 97,7 288,7 Nov 13 -90,9 197,8 Dec 13 33,1 230,9

And I would like to receive the highest value from the cumulated column (col 3): 288.7 Oct 13

Any suggestions?

• ###### Re: Max value of Aggregation

Something like this:

max(aggr(RANGESUM(

ABOVE(

SUM({<

[Measures (Key)]={'Operating Profit (EBIT)'},

[Version single (Key)]={'Actual'},

Period,

[Year period 1]={\$(vTwelveMonthRolling_All)}

>}Values)/1000000

,

0

,

RowNo()

)

)

,[Year period 1]))

See attached example.