Useing Excel Function NORMSINV() in BEx
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.