1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Calculation in Tabular/Detail form in apex 4.1

Discussion in 'Oracle Application Express (APEX)' started by kam_oracle_apex, Nov 19, 2014.

  1. kam_oracle_apex

    kam_oracle_apex Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi Friends,

    I am working on apex4.1. i have a master detail. i want some calculation in detail form. detail are as follows;

    I have three fields in detail form.
    1. rate (Input)
    2. qty (Input)
    3. amount (Display)
    I want to multiply rate*qty and result should be shown in amount field.
    how would i do it through Dynamic Action ?

    Please help,

    Regards
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Do you need this in report or form ?
     
  3. kam_oracle_apex

    kam_oracle_apex Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    As i have mentioned earlier. i want in Form.
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Firstly place Rate and Quantity Fields in the form and then after creating the form, open the form query and place Amount field by writing formula rate * qty and make this field as display only.