Hi,
I have a requirement in which I need to Calculate failure percentage using (failure/(failure+ success)) *100
Failure and success are the two columns present in my table. When I am applying this formula in analysis, I get weird results.
By analysing the query generated by Obiee, I could find that it applies floor function by default. On removing the floor function and running on oracle gives me the correct results.
So, can anyone please tell me, how should I remove this default floor function in obiee to get the correct results?
Help will be appreciated
Regards,
Dolly