--// Details
SELECT COALESCE(SUM(isnull(ColumnName,0)) / NULLIF(SUM(isnull(ColumnName,0)),0), 0)
--// Function
SELECT COALESCE(SUM(isnull(0,0)) / NULLIF(SUM(isnull(0,0)),0), 0)
--// Result
0.000000
Excel :: Text :: 1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula :: TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...
No comments:
Post a Comment