This discussion is archived
6 Replies Latest reply: Jul 10, 2013 1:46 AM by RajuM RSS

Calculated non-base table field in a tabular form

S.Bovin Newbie
Currently Being Moderated

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




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





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

3       5          15

10      50         500

20      3           60



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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points