6 Replies Latest reply on Jun 12, 2018 8:49 AM by vladimir.tenchev

    Null aggregation if summing over any null values

    vladimir.tenchev

      Hi,

       

      I am working with simple timeseries data [date, value]. I am creating a report with a set of filters that define the relevant timeseries for aggregation.

      The issue I have is that by default the SUM function treats null values as 0 and returns what I consider an "incomplete" aggregation. I would like a sum function that returns an error or null value instead ... hopefully the table below clarifies.

       

      DateSeries 1Series 2Series 3CustomSum(filter = series 1, series 2, series 3)CustomSum (filter = series 1, series 2)
      01/01/201812363
      02/01/201812363
      03/01/201813
      04/01/201812363
      05/01/201812363
      06/01/2018123

       

      Can someone suggest what setting I can change for the SUM function or how to create a custom sum function that achieves this?

       

      Many thanks,

      Vladimir