6 Replies Latest reply: Jul 10, 2013 3:46 AM by RajuM RSS

    Calculated non-base table field in a tabular form

    S.Bovin

      I am struggling with creating a non-base table calculated field in a tabular form in ApEx 3.1

      Can you point me in the right direction

       

      I thought this would be fairly easy to do, but I cant work out how to do it

       

      Requirements

       

      1) Tabular Form based on a table with QTY and PRICE columns

      2) TOTAL is a non-base table field, based on QTY * PRICE

      3) If the Qty or Price changes, the TOTAL should be re-calculated

       

      Example

       

      QTY   PRICE  TOTAL

      ===    =====  =====

      3       5          15

      10      50         500

      20      3           60

       

      Environment

      ApEx 3.1, Oracle 10 and Oracle 11 databases

      I recommended to upgrade to a newer version of ApEx but the request was rejected so Im stuck with 3.1