Skip to Main Content

APEX

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!

HTML PAGE: formula IF Conditional Expression? IF Command?

711211Oct 30 2009 — edited Nov 9 2009
Hello -

I am creating a 1 page 'calculator' within Apex. I have it in Excel, but I don't want to send my Excel workbook to folks.

I need a push in the right direction for learning how to do this using Oracle formulas, particularly in place of my Excel 'if' formulas.

I found Oracle's guide for: FOrmula Language User's Guide but I'm getting an ORA-06550 message, complaining about the ? in my expression.... I also found Oracle 9i OLAP Developer's Guide.... working with expressions

one place is talking about: expression ? expression2 : expression3
Another place has: IF Boolean-expression THEN expression1 ELSE expression2

I've also tried: CASE WHEN expression1 THEN expression2 ELSE expression3


I need to know the syntax or format for:

if ( (:p1_item1 > 0) then :p1_item1 / :p1_item2 ELSE 0)

Thank you -
Marion
This post has been answered by Sc0tt on Oct 30 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2009
Added on Oct 30 2009
19 comments
2,134 views