java中的sum over_SQL总和（分区）不减去SUM中的负值

我有以下查询，它输出每个用户的交易清单 - 花费的单位和赢得的单位 - 列'金额' .

我已设法按用户对此进行分组并执行总计 - “Running_Total_Spend”列 .

然而，它是添加负数'Amount'值而不是减去它们 . Sp非常确定查询的SUM部分不起作用 .

WITH cohort AS(

SELECT DISTINCT userID FROM events_live WHERE startDate = '2018-07-26' LIMIT 50),

my_events AS (

SELET events_live.* FROM events_live WHERE eventDate >= '2018-07-26')

SELECT cohort.userID,

my_events.eventDate,

my_events.eventTimestamp,

CASE

--spent resource outputs a negative value ---working

WHEN transactionVector = 'SPENT' THEN -abs(my_events.productAmount)

--earned resource outputs a positive value ---working

WHEN transactionVector = 'RECEIVED' THEN my_events.productAmount END AS Amount,

ROW_NUMBER() OVER (PARTITION BY cohort.userID ORDER BY cohort.userID, eventTimestamp asc) AS row,

--sum the values in column 'Amount' for this partition

--should sum positive and negative values ---NOT WORKING--converting negatives into positive

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

SUM(CASE WHEN my_events.productAmount >= 0 THEN my_events.productAmount

WHEN my_events.productAmount <0 THEN -abs(my_events.productAmount) end) OVER(PARTITION BY cohort.userID ORDER BY cohort.userID, eventTimestamp asc) AS Running_Total_Spend

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

FROM cohort

INNER JOIN my_events ON cohort.userID=my_events.userID

WHERE productName = 'COINS' AND transactionVector IN ('SPENT','RECEIVED')