APEX

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