TSQL - Using Sum Function

Hi guys,
I am looking for a solution to the problem described below (SQL SERVER 2000).
Thanks in advance for any help,
Aldo.

The script below:



Code Snippet
SELECT
Data.[Invoice No] AS 'InvoiceNo',
[JurnalTrans.REF2] AS 'JurnalTrans.REF2',
[JurnalTransMoves.SUF] AS 'JurnalTransMoves.SUF',
[RowIDDataLevel] AS 'RowIDDataLevel',

CASE WHEN RowIDDataLevel = 1 THEN CAST(Paid AS int) ELSE '0' END AS 'Paid' ,

CASE WHEN RowIDDataLevel = 1 THEN CAST([JurnalTransMoves.SUF] - [Paid] AS int) ELSE '0' END AS 'OutstandingBalance'

FROM CTE AS Data
INNER JOIN (SELECT [Invoice No], SUM([JurnalTransMoves.SUF]) AS Paid FROM CTE GROUP BY [Invoice No]) AS SUMSUF ON SUMSUF.[Invoice No] = DATA.[Invoice No]

ORDER BY [Accounts.ACCOUNTKEY], Data.[Invoice No], [RowIDDataLevel]

Gives these results:

Invoice No JurnalTrans.REF2 JurnalTransMoves.SUF RowIDDataLevel Paid OutstandingBalance

----------- ---------------- ---------------------- -------------- ----------- ------------------

5752 NULL 1155 1 1810 -655

5752 2032 400 2 0 0
5752 2033 155 3 0 0

5752 2034 100 4 0 0

5754 NULL 1732.5 1 2482 -750

5754 2035 750 2 0 0

16687 NULL 2555.8 1 2555 0


Where:
1810 (Paid) = 1155 + 400 + 155 + 100

2482 = 1732 + 750
and so on...

What I need is to get:
instead of 1810 ==> 655 = 400 + 155 + 100
instead of 2482 ==> 750
and so on...

In order to do that, I tried inserting "WHERE RowIDDataLevel Not In (1) " in the line:


Code Snippet
INNER JOIN (SELECT [Invoice No], SUM([JurnalTransMoves.SUF]) AS Paid FROM CTE WHERE RowIDDataLevel Not In (1) GROUP BY [Invoice No]) AS SUMSUF ON SUMSUF.[Invoice No] = DATA.[Invoice No]

and then getting the following:

InvoiceNo JurnalTrans.REF2 JurnalTransMoves.SUF RowIDDataLevel Paid OutstandingBalance

----------- ---------------- ---------------------- -------------- ----------- ------------------

5752 NULL 1155 1 655 500

5752 2032 400 2 0 0

5752 2033 155 3 0 0

5752 2034 100 4 0 0

5754 NULL 1732.5 1 750 982

5754 2035 750 2 0 0


That it is almost what I need, but not good enough because it makes the line marked in red to disappear because of RowIDDataLevel =1
16687 NULL 2555.8 1 2555 0
to disappear.