Array_sum analytics

Couchbase Server
1

Hi,

What is the equivalent syntax below in analytics N1QL?

ARRAY_SUM(ARRAY v.netAmount FOR v IN o.itemList WHEN v.itemClassification = ‘REGULAR’ END) AS regular

2

Use subquery expression (N1QL and Analytic)

(SELECT VALUE  SUM(v.netAmount) 
   FROM o.itemList  AS v
     WHERE v.itemClassification = "REGULAR")[0] AS regular
3

Thanks so much @vsr1!