Skip to Main Content
Forums

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!

Math function to show only positive numbers?

EricPSUJun 22 2010 — edited Jun 30 2010
Does anyone know of a math function to show only positive numbers. I have a formula that returns an integer, if the integer is negative, I want it to show ZERO. I'd prefer to not have to use a case statement.

For example, if it returns 5, I want to see 5. If it returns 0, I want to see 0. If it returns -2, I want to see 0.
This post has been answered by David_T on Jun 22 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2010
Added on Jun 22 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
10 comments
5,058 views