SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to sum on condition

687347Mar 28 2009 — edited Mar 29 2009

Hello,
I have the following data:

INSTRUMENT_TYPE INSTRUMENT_CODE DESCRIPTION TRADE_DATE  QUANTITY OPEN_CONTRACTS TRADE_AMOUNT TRANSACTION_ID 
fceu            USDEUR QSA2     USD/EUR     10.11.2008   1700000        1700000  -1323575.21          1819 
fceu            USDEUR QSA2     USD/EUR     25.11.2008  13300000       15000000 -10233130.72          1882 
fceu            USDEUR QSA2     USD/EUR     28.11.2008 -15000000              0  11598237.07          1908 
fceu            USDEUR QSA2     USD/EUR     04.02.2009    283000         283000   -218456.91          2141 
fceu            USDEUR QSA2     USD/EUR     11.02.2009    215000         498000   -166215.69          2185

where OPEN_CONTRACTS is a running total of QUANTITY.
I have to SUM(TRADE_AMOUNT), but the sum must reset whenever OPEN_CONTRACTS goes to 0.
Is this possible without writing an external procedure ?

TIA
claudio

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2009

Added on Mar 28 2009

8 comments

15,414 views