SUM(ARRAY_COUNT(query)) returning null

sri_ram · November 25, 2019, 11:45am

Hi

SUM(ARRAY_COUNT(query)) returns null if there are no documents matching condition. Is it possible to return Zero(0) instead of Null

Regards,
Venkat

vsr1 · November 25, 2019, 1:36pm

wrap around IFMISSINGORNULL(XXX, 0) or case statement

sri_ram · November 25, 2019, 3:20pm

@vsr1 thanks a ton it worked

Topic		Replies	Views
Prevent SUM() for returning NULL SQL++	1	2110	May 28, 2015
SUM() always return null on existing values SQL++	2	2165	November 3, 2017
Empty N1QL Response Node.js SDK query , n1ql	3	1969	January 24, 2016
How can I return a null or empty string if a key value does not exist? SQL++	1	1196	January 11, 2022
Try to calculate percentage but subquery returns null SQL++ 40-beta	3	983	June 4, 2020

SUM(ARRAY_COUNT(**query**)) returning null