HTML PAGE: formula IF Conditional Expression? IF Command?
711211Oct 30 2009 — edited Nov 9 2009Hello -
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