Max value from a list

[#1]

What would be the fastest and easiest way to find the maximum value from a list of a key-figure like, lets say Monthly Sales?

[Former Member]

On the desired Keyfigure, right click --> properties --> Calculations --> Calculate Single Value as --> Select Maximum.

Hope this helps.

Thanks,

Naveen Rao Kattela

[Former Member]

Can you please tell me how the MAX() function works in the formula builder, it is supposed to take 2 parameters like this:

MAX(parameter 1;parameter 2). Thanks

[Former Member]

Hello,

 Can you please tell me how the MAX() function works in the formula builder, it is supposed to take 2 parameters like this:
MAX(parameter 1;parameter 2). 

It doesn't work like excel - ranges are not supported.

As parameter you can use only objects that are visible in available operands (key figures, selections, formulas, formula variable) i.e. it basically compares 2 numbers.

To address your problem:

I suggest you select Calculate result as maximum - to see maximum in result row.

If you want to see maximum in column, then you create formula and use function Result/Overall Result on Monthly Sales. Function is found in data functions.

BR

Ondrej

[Former Member]

Thanks for the info on MAX. I tried using Result and Overall Result but that didn't help. I have tried Exception Aggregation and that's not helping, I have tried creating a formula and then create a condition on that formula like TopN value 1 and that's not working . I mean how difficult is it in BW to pick a Max value from a list. In school I wrote Java and Python methods from scratch to find Max values in a list Basically you got to sort and do comparisons. I can't believe that something so simple and intuitive is so cumbersome in SAP. I am searching forums and looking for documentation for this but so far no luck. I appreciate all the answers and help I am getting from you guys. Thanks.

[anshu_lilhori]

Hi,

Try this make a new formula and put your amount keyfigure inside it then hit the aggregation tab and excption aggregation as MAX and reference characteristic as day.Now in result you will get 120 value.

Again make a new formula as SUMCT(F1) the formula which you created earlier.Now you will get 120 in every cell.

In case you dont want to display it in each cell then you can select calculate single value as hide.

Hope it helps and works.

Regards,

AL

[Former Member]

Hello,

My bad sumct really does only SUM.

However it's even easier - just use calculate single value as maximum on KF Monthly Sales. I've just checked it.

BR

Ondrej

[Former Member]

Thanks everyone for the input, I tried all the proposed suggestions but the optimal solution for me was to create a condition with TopN and Value = 1 and then in Character Assignment I selected "All Individual Chars. and Char.Combinations" and then selected the characteristics which helped give the maximum. Thanks again for all your help, It was a good exercise in learning how the different methods give a max value but each has its own nuances. For its Calculate Result as, Exception Aggregation with Maximum value and creating a condition with TopN and 1.