Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour ;
What is the Result of :
RANGESUM(1, 2, 'abc', NULL(), 5) |
8
RangeSum will add all numeric value and all non-numeric will be considered as 0
8
RangeSum will add all numeric value and all non-numeric will be considered as 0
8 would be the answer
Result is 8
Helpful
Hi,
Rangesum will treat all non-numeric values as 0.
rangesum (1,2,4) | returns 7 |
rangesum (1,'xyz') | returns 1 |
rangesum (null( )) | returns 0 |
rangesum (above(count(x),-1,3)) | returns the sum of the three results of the count(x) function evaluated on the row below the current row, the current row and the row above the current row. |