Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove default floor function while dividing a column by another in OBIEE

DollyGDec 28 2017 — edited Dec 28 2017

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

This post has been answered by Gianni Ceresa on Dec 28 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details