Useing Excel Function NORMSINV() in BEx

[Former Member]

Hi All,

I am having a requirement where i have to generate a Query like below.

Plant | Service Lvl | Cost | Time | Deviation

Z (Service Lvl) = Should be calculated based on FUNCTION NORMSINV(Service LVL), the service level percentage they enter in selection screen.

then use this in formula to calculate other column value i.e COST

COST = ZSQRT(Time)Deviation.

Please help me how to, solve this in BEx reporting.

Waiting for your reply.

[Former Member]

BEx does not have statistical type of operators. You will most likley need to do this with excel. Sorry.

Jeff

[victor_yang2]

I don't know if I understand clearly. Are you trying to put some calculation in Excel?

You can create macro in

Sub SAPBEXonRefresh(queryID As String, resultArea As Range).

[Former Member]

My requirement is .....

How to implement a function LIKE Excel's NORMSINV() as a Calculated key Figure inside BW?

Please help me...so that i can reward you points

[former_member188325]

Hi,

what does NORMSINV() do in excel?i have no idea.Can you give one example?

Thanks

[vinay_bedre2]

This function is available only in MS excel and it is possible for you to make use of this in BEx Analyzer.

You can implementthis kind of functionality/requirement only in customer exit. that is SAPBExonRefresh function.

But you cant use this feature as Calculated key figure.

What can be done:-

In column M, assume you are displaying some results...

now in column O, you define some formulaes(depends on row M)These formulaes are defined in SAPBExonRefresh subroutine.

Regards,

Vinay