SMALL & LARGE Function in BW ?

[Former Member]

Hi, we try determine the "Price Difference in %".

But this calculated key figure is disponible only in BBP content, we only use 0PUR_C01 data.

For my client the months is dynamic value.

Example for last 3 months, my Client use Small and Large function in excel to determine whether the price increases or decreases.

Where increasing use Formula1 and in case of diminishing use to formule2.

Any idea for alternatives ?

Thank you.

[Former Member]

We use MAX and MIN Function, very complex Query, this functions only work using two values.

[Former Member]

Hi Victor,

Try to create caluculated key figure

Then use min & max functions..........

please refer the below url.

http://help.sap.com/saphelp_nw04/helpdata/en/6f/56853c08c7aa11e10000000a11405a/content.htm

Thanks,

Vijay.

[Former Member]

Hi, MIN and MAX working for more the two keyfigures ?

We need determine the max value in 12 statics months.

[Former Member]

Hi,

Please give more clarification on the requirement.

Thanks,

Kartik

[Former Member]

Hi kartik, in resume we need determine whether the price increases or decreases.