Former Member

# Get values through customer exit in BEx

Hi Frnds ,

i have a requirement to read values dynamically based on user entry ,

For Example if a user selects Order = from 3000000201 to 3000000401 while executing a query , i need to get the maximum , mininmum and average days ,

The datatarget will have data like this

Order No Of Days

3000000201 2 days

3000000203 5 days

3000000300 4 days

3000000401 5 days

here the max days is 5 the min days is 2 and the average is 4 days

Hance the query output should have the result like this ,

Order No Of Days Max MIn Avg

3000000201 2 days 5 2 4

3000000203 5 days 5 2 4

3000000300 4 days 5 2 4

3000000401 5 days 5 2 4

Is it possible to achieve this in Bex , Thanks for your valuable sugesstions

If this can be achieved through customer exit please show some draft code sample to achieve this logic

Thanks ,

sathy

10|10000 characters needed characters exceeded

### Related questions

Posted on Jan 03, 2008 at 09:15 AM

Hi Satya,

For the three calculated Key Fig that you have created keep the calculate result as and calculate Single value As option as Nothing Defined.

And do an Exception Aggregation on all three Calculated Key Fig with Maximum, Minimum and Average of all values with refernce to the Characteristic Order NO.

Try this out

10|10000 characters needed characters exceeded
• Former Member Former Member

Hi Rakesh ,

Sorry for a very late reply ,

i am not able to fix this but able to convince the business to check for maximum and minimum values only in the result column ,

Thanks a lot for your support ,

• Former Member
Posted on Jan 02, 2008 at 02:28 PM

Hi Sathya.

You can achieve this if you add the key figure to the structure four times and then go to the calculations tab -> change calculate single values to minimum, maximum and avarage of all values.

Hope it helps.

BR

Stefan

10|10000 characters needed characters exceeded
• Former Member Rakesh Pattani

HI Rajesh ,

I tried in the same as you have explained , but it shows always ' 0 ' even the result in having values , i have no idea why it happens ,

i have verified the SUMGT function in help,sap as well , its explaining the same as you have told but its does not work for me ,

im in 3.5 version , Do you have any idea