14 Replies Latest reply on Dec 19, 2013 8:18 AM by 994122

    how to do a sum of text_field or a column with where condition?

    Vijetha

      Hi all,

      In Oracle forms 6i, i have created a form in which there are 5 text_Items (with 20 no of fields displayed) namely ACCOUNT FD NO, AMOUNT, INTEREST RATE, STATUS and INTEREST_YEAR.

       

      ACCOUNT FD NO

      AMOUNT

      INTEREST RATE

      STATUS

      INTEREST_YEAR

      47665

      50000

      1. 11.5

      E

      5750

      37463

      60000

      12

      D

      7200

      47651

      100000

      1. 12.5

      D

      12500

      34766

      70000

      11

      E

      7700

       

      I want to make sum of INTEREST_YEAR where status='E'.

      I have created a field by name TOTAL_INTEREST_YEAR in which i want to display the sum.

      How do i do sum with where condition ??

      Thank You.

       

      Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

      Oracle Form Builder 6i.